Forum Discussion

avalerion's avatar
avalerion
Frequent Visitor
8 years ago
Solved

Nested Measure

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 func...
Need Help
  • avalerion's avatar
    avalerion
    8 years ago

    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.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

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's avatar
    avalerion
    Frequent Visitor
    8 years ago

    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's avatar
      v-huizhn-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      8 years ago

      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