Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello community! I created this measure to sum total savings between two dates, [Monthly Updated Transition Date] & [End Transition Date], using an IF statement:
JUL Savings =
IF(DATE(2022, 7, 1) >= MIN('Project Data'[Monthly Updated Transition Date]) && DATE(2022, 7, 1) < MIN('Project Data'[End Transition Date]),
SUMX(VALUES('Project Data'[Concatenate]),
CALCULATE(SUM('Query_Sums'[JUL ]) * SUM('Project Data'[Savings per SKU (per actual case)]))
),
BLANK()
)
While this evaluates a result for each Project Name, it does not evaluate a Total in the matrix visual:
Are there other ways to re-write the DAX, such as by using ISONORAFTER? Thanks so much for your help in advance!
Solved! Go to Solution.
Hi @alvinlinjr
Please try
JUL Savings =
SUMX (
VALUES ( 'Project Data'[Concatenate] ),
CALCULATE (
IF (
DATE ( 2022, 7, 1 ) >= MIN ( 'Project Data'[Monthly Updated Transition Date] )
&& DATE ( 2022, 7, 1 ) < MIN ( 'Project Data'[End Transition Date] ),
SUM ( 'Query_Sums'[JUL ] )
* SUM ( 'Project Data'[Savings per SKU (per actual case)] ),
BLANK ()
)
)
)
Hi @alvinlinjr
Please try
JUL Savings =
SUMX (
VALUES ( 'Project Data'[Concatenate] ),
CALCULATE (
IF (
DATE ( 2022, 7, 1 ) >= MIN ( 'Project Data'[Monthly Updated Transition Date] )
&& DATE ( 2022, 7, 1 ) < MIN ( 'Project Data'[End Transition Date] ),
SUM ( 'Query_Sums'[JUL ] )
* SUM ( 'Project Data'[Savings per SKU (per actual case)] ),
BLANK ()
)
)
)
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
71 | |
37 | |
21 | |
18 | |
15 |
User | Count |
---|---|
126 | |
32 | |
27 | |
24 | |
23 |