Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |