One of the first concepts to learn in DAX is the difference between calculated columns and measures. This article shortly recap the differences.
Author Archives: Costas Kounadis
Lead And Lag Functions In SQL Server
KPI performance charts & dashboards – 43 alternatives (contest entries) | Chandoo.org – Learn Microsoft Excel Online
Hello all, prepare to be amazed! Here are 43 creative, fun & informative ways to visualize KPI data. About a month ago, I asked you to visualize KPI data. We received 65 entries for this con…
Calculate previous month, quarter without using string gymnastics – Daniel Bowlin’s SQL Server BI Blog
This article outlines methods to calculate previous month, quarter, or previous period from a current period column in a date dimension or other table.
Introducing Google Chart In ASP.NET MVC 5
Restore Generated SQL Scripts Of Table With Records Into Another Database
Power Query & Power BI are ideal learning paths from Excel to R – The BIccountant
Excel users who start to learn Power Query will find learning R quite easy once they’ve started to play around with Power Queries M code. Smooth transition!
Πηγή: Power Query & Power BI are ideal learning paths from Excel to R – The BIccountant
Apply AND Logic to Multiple Selection in DAX Slicer
Apply AND Logic to Multiple Selection in DAX Slicer – SQLBI http://www.sqlbi.com/articles/apply-and-logic-to-multiple-selection-in-dax-slicer/ (Κοινή χρήση από CM Browser)
Transfer values to other columns in Power Query | Excel Inside
What we have to do if our source is a mix of tabular data and important values outside the tables? We need to transfer this values to a new column in the tables
Πηγή: Transfer values to other columns in Power Query | Excel Inside
