Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I'm using this code to create a YTD-function for ISO Year and weeks taken from https://www.sqlbi.com/articles/week-based-time-intelligence-in-dax/
IsoYTD :=
IF (
HASONEVALUE ( Dates[ISO Year] ),
CALCULATE (
SUM ( Sales[Sales Amount] ),
FILTER (
ALL( Dates ),
Dates[ISO Year] = VALUES ( Dates[ISO Year] )
&& Dates[Date] <= MAX ( Dates[Date] )
)
),
BLANK ()
)
Solved! Go to Solution.
Problem solverd
IsoYTD :=
IF (
HASONEVALUE ( Dates[ISO Year] ),
CALCULATE (
SUM ( Sales[Sales Amount] ),
FILTER (
ALL( Dates ),
Dates[ISO Year] = VALUES ( Dates[ISO Year] ) - 1
&& Dates[Date] <= MAX ( Dates[Date] )
)
),
BLANK ()
)
Problem solverd
IsoYTD :=
IF (
HASONEVALUE ( Dates[ISO Year] ),
CALCULATE (
SUM ( Sales[Sales Amount] ),
FILTER (
ALL( Dates ),
Dates[ISO Year] = VALUES ( Dates[ISO Year] ) - 1
&& Dates[Date] <= MAX ( Dates[Date] )
)
),
BLANK ()
)
User | Count |
---|---|
42 | |
28 | |
24 | |
20 | |
16 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |