Forum Discussion

Bokazoit's avatar
Bokazoit
Icon for Continued Contributor rankContinued Contributor
5 years ago

Accumulate quarters

This meaure works well for month but as soon as I drill to quarter it gives me accumulated up till last quarter i.e. Q1. I need it to show for Q2 also even though it is not finished yet: acc = ...
Need Help
daxer-almighty's avatar
daxer-almighty
Icon for Solution Sage rankSolution Sage
5 years ago
acc =
VAR Today_ = TODAY ()
var EffectiveDates =
    INTERSECT(
        DISTINCT( DimDato[Dato] ),
        CALCULATETABLE(
            DISTINCT( DimDato[Dato] ),
            DimDato[Dato] <= Today_,
            REMOVEFILTERS( DimDato )
        )
    )
VAR RTotal =
    CALCULATE (
        SUM ( FactFinans[#Bogførtbeløb] ),
        CALCULATETABLE(
            DATESYTD( DimDato[Dato] ),
            EffectiveDates
        ),
        REMOVEFILTERS( DimDato )
    )
return
    RTotal