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 )
    )
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
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 )
    )
sqldev2017's avatar
sqldev2017
Microsoft Employee
7 years ago

That worked like a Charm. 

 

Thank You.

 

Honestly,  I was trying to do this FORMAT(Measure, "String")  , that was not working.

 

This worked.