Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All--
I would expect the highlighted amount to be the difference between Q4 & Q1 = 29,251 – 28,723 = $528.
Below is my code.
Solved! Go to Solution.
That's working out the percentage. Try
QoQ $ $ =
IF(
ISFILTERED('ICC Reports'[Date]),
ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column."),
VAR __PREV_QUARTER = CALCULATE(SUM('ICC Reports'[$]), DATEADD('ICC Reports'[Date].[Date], -1, QUARTER))
RETURN
SUM('ICC Reports'[$]) - __PREV_QUARTER
)
That's working out the percentage. Try
QoQ $ $ =
IF(
ISFILTERED('ICC Reports'[Date]),
ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column."),
VAR __PREV_QUARTER = CALCULATE(SUM('ICC Reports'[$]), DATEADD('ICC Reports'[Date].[Date], -1, QUARTER))
RETURN
SUM('ICC Reports'[$]) - __PREV_QUARTER
)
Thankk you so much.
User | Count |
---|---|
48 | |
44 | |
19 | |
14 | |
14 |
User | Count |
---|---|
107 | |
55 | |
28 | |
20 | |
15 |