One of the first concepts to learn in DAX is the difference between calculated columns and measures. This article shortly recap the differences.
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
