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.
I am trying to calculate the sum of revenue for 2022 of a all products given that they have sales in a given periode (after 30.06.2022).
That is measure [Price 30.06] is not blank or 0.
The following is my attempt:
IF([Price 30.06] <> blank() || [Price 30.06]<>0, calculate([Revenue], Dates[Year]==2022, ALL(Products_table))
However, the all() formula seems to ignore the IF() command, and adds all products for the period.
Price 30.06 = calculated price after 30.06 // sum(DF_table(revenue)/sum(DF_table(quantity))
Revenue = sum(DF_table(revenue))
Products_table is connected to DF_table by item_id
Dates is connected to DF_table by dates column
Solved! Go to Solution.
Apologies, part of my inital syntax was incorrect, what solved it was the following:
Apologies, part of my inital syntax was incorrect, what solved it was the following:
(after and including 2 Jan)
Regards,
Ritesh
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
64 |