Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi
I have to create 3 measures based on intervals from the "Difference in days" column and if the column "Our Mistake" equals "No".
Measure1: sum Qty if "Difference in days" => 0 and <8 and "Our Mistake?" = "No"
Measure2:sum Qty if "Difference in days" =>8 and <21 and "Our Mistake?" = "No"
Measure3:sum Qty if "Difference in days" => 21 and <200 and "Our Mistake?" = "No"
Qty | Difference in days | Our Mistake? |
300 | 5 | Yes |
1500 | 40 | No |
Can you help me do the correct formulas for creating the measueres in PowerBi?
Thanks
@KasperJ90
Add the following three measures
Measure1 =
SUMX(
FILTER(Table6, Table6[Difference in days] >= 0 && Table6[Difference in days] < 8 && Table6[Our Mistake?] = "No"),
Table6[Qty]
)
Measure2 =
SUMX(
FILTER(Table6, Table6[Difference in days] >= 8 && Table6[Difference in days] < 21 && Table6[Our Mistake?] = "No"),
Table6[Qty]
)
Measure3 =
SUMX(
FILTER(Table6, Table6[Difference in days] >= 21 && Table6[Difference in days] < 200 && Table6[Our Mistake?] = "No"),
Table6[Qty]
)
________________________
If my answer was helpful, consider Accepting it as the solution to help other members find it
Click the Thumbs-Up icon if you like this answer 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
User | Count |
---|---|
101 | |
90 | |
79 | |
70 | |
70 |
User | Count |
---|---|
112 | |
96 | |
96 | |
75 | |
72 |