Forum Discussion

MightyMicrobe's avatar
MightyMicrobe
Icon for Helper II rankHelper II
6 years ago

Measure for Previous Week Based on Index

Hi all, I have a table with a numeric index indicating Weeks Back from today.      I need to create a measure indicating the value of the previous week, based on the index.  I can successfully do...
Need Help
Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper User
6 years ago

MightyMicrobe ,

 

If you want it to use in measure so use MAX instead of EARLIER. Because EARLIER is not supported in measure.

 

 

MightyMicrobe's avatar
MightyMicrobe
Icon for Helper II rankHelper II
6 years ago

Yes, this is the bit that threw me -- I didn't think of using MAX/MIN instead of EARLIER. 

 

My final formula is this:

Total User Previous Period = 
CALCULATE([Total Users], 
FILTER(ALL('Asset Customer Activity'), 'Asset Customer Activity'[Weeks Back]=MIN('Asset Customer Activity'[Weeks Back])+1))
 
I do have a calendar table, but for this particular query I'm using the index already there (long story).