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...
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]))