Forum Discussion

Penn's avatar
Penn
Icon for Resolver I rankResolver I
7 years ago
Solved

How to write this measure in DAX?

Hi all,   I have a table [Opportunity History] that looks like this and I have independent date table 'Calendar'. How do I create a measure that return the last stage at each month end (with a mont...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
7 years ago
Stage EOM = CALCULATE(MAX([Stage]), FILTER(all('Opportunity History'), 'Opportunity History'[Date Time] <= MAX('Calendar'[This Month End])))

 

Try All. Also I think it should be = not <=