Forum Discussion

sqldev2017's avatar
sqldev2017
Microsoft Employee
7 years ago
Solved

Help with Simple DAX formula

  I am doing something like this -    PreviousMonth = FORMAT(CALCULATE(MIN(DimDate[Month]), FILTER(DimDate, DimDate[Month_Year] = [SelectedMonthYear]) ), "String")   -  Min(DimDate[Month])  ret...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    sqldev2017

     

    Try storing the MEASURE value in a variable first

     

    Revenue =
VAR myMEASURE = [MonthYear]
RETURN
    CALCULATE (
        SUM ( fact[Revenue] ),
        FILTER ( fact, fact[fiscalMonth] = myMEASURE )
    )
MFelix's avatar
MFelix
Super User
7 years ago

Hi sqldev2017,

 

What do you want to use this measure for? what is the context and calculation you arre making on the other measure where this one is used?

 

Regards,

MFelix