Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Bokazoit
Responsive Resident
Responsive Resident

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 =

VAR __MaxYT = MAX(DimDato[År])
var __MaxDT = max(DimDato[Dato])
var __TD = TODAY()
var __Rtotal =
CALCULATE(sum(FactFinans[#Bogførtbeløb]),
Filter(
All(DimDato),
DimDato[År] = __MaxYT
&& DimDato[Dato] <= __MaxDT)
)

RETURN
IF (__MaxDT >= __TD, BLANK(), __Rtotal)
 
The IF part blank out numbers in future, and I think that is where I need the helt
1 REPLY 1
daxer-almighty
Solution Sage
Solution Sage

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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.