Forum Discussion

DaveC123's avatar
DaveC123
Frequent Visitor
9 years ago
Solved

New Measure = Today's data compared to the average

I have a spreadsheet that I update daily.  I need a "new measure" to capture today's data (the last data in the column) to be able to use it as a field on a visual in order to compare it to the avera...
Need Help
DaveC123's avatar
DaveC123
Frequent Visitor
9 years ago

This is a great formula.  So now the 1 moves as the days data gets filled in.  But, I am stuck trying to still have that days data captured for use on a chart or as a "new measure".  The chart value shows "1".  I do not know how to write DAX, obviously, but was thinking something like this in order to create a "new measure": ?

 

      Todays SO = If('PowerBI Data Table'[Current Day],1,then('PowerBI Data Table'[Sales Orders] Column D)  

 

I was hoping this would pickup that cell which has todays Sales Order number.  In the earlier table; 51 

 

 

 

 

OpenDataLab's avatar
OpenDataLab
Icon for Helper II rankHelper II
9 years ago

Dave C123 please take a look at the sample workbook I provided, this will show you how to use the flag.

 

You can use it as either a report, page or visual filter. I have set it up as a visual filter on the sample.  

 

This then allows you to see all the history on the other graphs on the report, whilst the bars chart (or other visual) show just the current day.

 

https://onedrive.live.com/embed?cid=FCBE4E6107649D72&resid=FCBE4E6107649D72%21114&authkey=AB5tPodWSHlUf1Q