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.
Dear.
I would appreciate your help in the following consultation:
I need to filter the values ending in three zeros for the following DAX formula:
Movimientos = CALCULATE(MIN(MB51_TODO[Fe.contab.]),
MB51_TODO[CMv]="101" || MB51_TODO[CMv]="501" ||
MB51_TODO[CMv]="201" || MB51_TODO[CMv]="202" ||
MB51_TODO[CMv]="221" || MB51_TODO[Ce.] ="1000")
I need a filter on the following argument:
MB51_TODO[Ce.] ="1000") Only values ending in "000" need to be filtered.
Also, if there were any ideas for reducing the length of my formula, I would appreciate it.
Solved! Go to Solution.
Hi @JMOLLAN ,
You can update the formula of the measure [Movimientos] as below:
Movimientos =
CALCULATE (
MIN ( MB51_TODO[Fe.contab.] ),
FILTER (
MB51_TODO,
MB51_TODO[CMv]
IN { "101", "501", "201", "202", "221" }
|| RIGHT ( MB51_TODO[Ce.], 3 ) = "000"
)
)
Best Regards
Hi @JMOLLAN ,
You can update the formula of the measure [Movimientos] as below:
Movimientos =
CALCULATE (
MIN ( MB51_TODO[Fe.contab.] ),
FILTER (
MB51_TODO,
MB51_TODO[CMv]
IN { "101", "501", "201", "202", "221" }
|| RIGHT ( MB51_TODO[Ce.], 3 ) = "000"
)
)
Best Regards
Hey @Syndicate_Admin ,
Can you try the RIGHT function to check the last 3 chars? e.g.
RIGHT(MB51_TODO[Ce.],3)="000"
Movimientos = CALCULATE(MIN(MB51_TODO[Fe.contab.]),
MB51_TODO[CMv]="101" || MB51_TODO[CMv]="501" ||
MB51_TODO[CMv]="201" || MB51_TODO[CMv]="202" ||
MB51_TODO[CMv]="221" || RIGHT(MB51_TODO[Ce.],3)="000")
Cheers, LQ
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |