Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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 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
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
103 | |
98 | |
98 | |
38 | |
37 |
User | Count |
---|---|
154 | |
120 | |
73 | |
73 | |
63 |