Nested Measure

[avalerion]

I'm trying to simplify my formulas by relying on another defined measure, but can't seem to get it working.

In this example, the dates need to be shifted back a month but otherwise use the same function for the current month.

The measure in reference uses Dates[Date] as the driver and works fine.

Any thoughts on how to get this "nested" measure working?

VAR Date2 = PREVIOUSMONTH(Dates[Date]) RETURN
sumx(filter(Dates,Dates[Date]=Date2),[Revenue])

[Ashish_Mathur]

Hi,

Try this

=CALCULATE([Revenue],PREVIOUSMONTH(Dates[Date]))

There should be a relationship from the Date column of your base data table to the Date column of your Dates table.  In the Dates table, extract the month in another column by using the =FORMAT(Dates[Date],"mmmm") formula.  In your visual, drag the Month column from your Calendar table.

[avalerion · Accepted solution]

There are a dozen tables with dates and relationships within - so that's not really an option. All measures are written as some form of sumx(values(dates) or using max(dates) as a workaround.

[v-huizhn-msft]

Hi @avalerion，

The formula @Ashish_Mathur posted is right. What's meaning of "so that's not really an option"? Have you resolved your issue? If you have, welcome to share your solution or mark the right reply as answer. More people will benefit from here.

Thanks,
Angelia