Forum Discussion
emma313823
Helper V
Helper Vcalculating run rate to dynamically change
All, I have a measure I'm using that helps me obtain Average Monthly Revenue for the current year - and automatically adjusts the value by recalculating when a month closes. So if avg monthly re...
Could you simply use the Month function to get you a number?
MONTH function (DAX) - DAX | Microsoft Learn
I.e. Do a 12 minus that result?
Since July is 7, 12 - 7 = 5 which is the number you want?