Forum Discussion

Solle's avatar
Solle
Icon for Helper III rankHelper III
3 years ago

Summarize between selected dates from slicer

Hi All, I have a measure named "Afkast - Month Afkast" which generates each month return. Then I have a slicer which is using "between" as the style. What I want to accomplish is to generate the s...
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

HI Solle 
What is the dax for [Afkast - Month afkast]?

  • Solle's avatar
    Solle
    Icon for Helper III rankHelper III
    3 years ago

    Hi tamerj1 
    The dax for that measure is 

    Afkast - Month afkast = 
    IF(
        MONTH(SELECTEDVALUE('DimDate'[Date]))=1,
            SUM('FactAfkast'[Afkast eksl. FX]),
            SUM(FactAfkast[Afkast eksl. FX])-[Afkast - Previous month afkast])


    Let me know if you have any additional questions. 

    Best Regards,
    Solle

    • Solle's avatar
      Solle
      Icon for Helper III rankHelper III
      3 years ago

      And for the measure "Afkast - Previous Month Afkast" it is

      Afkast - Previous month afkast = 
        CALCULATE(SUM('FactAfkast'[Afkast eksl. FX]),PREVIOUSMONTH('DimDate'[Date]))