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