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.
Good day.
ROA=running of account
I wanted to get the previous month active customer by using:
Previous Month ROA = CALCULATE (DISTINCTCOUNT('Running of Account'[Debtor Code]), PREVIOUSMONTH('Running of Account'[Date]))
But i got no value.
For current month ROA I'm using:
Running of account data:
Thank you so much.
Solved! Go to Solution.
Hi @ommfin123 in general CALCULATE could accept many filter arguments.
In your part Name],), this red comma is extra?
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Proud to be a Super User!
Hi @ommfin123 in general CALCULATE could accept many filter arguments.
In your part Name],), this red comma is extra?
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Proud to be a Super User!
Dear @some_bih ,
The red comma removed. But it's said my syntax for PREVIOUSMONTH is incorrect.
Very greatful for your kindness.
Hi @ommfin123 if it was ok return it, sorry.
Proud to be a Super User!
Hi @ommfin123 DAX function PREVIOUSMONTH is one of the time intelligence functions in DAX, which works the best when applied on Date / Calendar table.
Try to change your part PREVIOUSMONTH('Running of Account'[Date])) to your Date table accordingly and check results. Hope this help
Proud to be a Super User!
Hi @some_bih ! Yeah! It's works! But I have a question too, I have repeated customers names with different customers' code, how can I add AND function to filter 2 conditions in this case?
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 |
---|---|
37 | |
25 | |
19 | |
14 | |
8 |
User | Count |
---|---|
69 | |
48 | |
44 | |
19 | |
15 |