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.
Hello Guys,
I'm trying to develop a report. I'am using a query from out Dynamics NAV.
This gives me the follwing information:
GL Account No and Amount. I want to do the following. I want to the amount specified by a range of GL Accounts No.
I want to create a measure.
I've tried the following:
Recurring Rev =
Calculate(Sum(RecREV[Amount]);Filter(RecREV[GL AccountNo] >= "8000" .. "8089")
Or
Calculate(Sum(RecREV[Amount]);Filter(RecREV[GL AccountNo] >= "8000" & <= "8089")
Using multiple filters is way to much work if I want to make a very specified range.
I hope you guys can help me out!
Solved! Go to Solution.
Hi @Flashed,
I would suggest you use the group function. Then the measure will be simple. If you want more details, please provide a dummy sample.
Best Regards,
Dale
Hi @Flashed,
I would suggest you use the group function. Then the measure will be simple. If you want more details, please provide a dummy sample.
Best Regards,
Dale
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 |
---|---|
113 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |