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, GL AccountNo is a text field?
If is a number field you can try with:
M = CALCULATE ( SUM ( RecREV[Amount] ); FILTER ( RecREV; RecREV[GL AccountNo] >= 8000 && RecREV[GL AccountNo] <= 8089 ) )
Regards
Victor
Lima - Peru
Hi,
Try this
=CALCULATE(SUM(RecREV[Amount]);RecREV[GL AccountNo] >= 8000;RecREV[GL AccountNo] <= 8089)
Hope this helps.
Hi, GL AccountNo is a text field?
If is a number field you can try with:
M = CALCULATE ( SUM ( RecREV[Amount] ); FILTER ( RecREV; RecREV[GL AccountNo] >= 8000 && RecREV[GL AccountNo] <= 8089 ) )
Regards
Victor
Lima - Peru
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 |
---|---|
105 | |
96 | |
79 | |
67 | |
62 |
User | Count |
---|---|
137 | |
106 | |
104 | |
81 | |
63 |