Report Portal

Automatically ranged date table using DAX and M

I am prepping some demo's for my SQLPass summit session "End-to-End Demos with Power BI" where I'll show many of the tricks I use in my Power BI workbooks. One of them is this trick that I recently figured out, I am so excited about it that I wanted to share it with all of you. I figured out a way to automatically generate a data table with a dynamic range based on the data in the fact tables.

Read more...

Tags: excel, dax, tabular

 

2007-2015 VidasSoft Systems Inc.