Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I can't figure out why the matrix is showing a matrix like this
with this dax of the addedd column:
While with a slightly different dax expression:
I got the correct matrix
I am scratching my head but can't figure out were is the issue.
Thank you for helping.
Hi @Vito ,
I looked at your first dax, do you mean that when the three conditions of OIS[Status]="Certified", OIS[MOnthCert] <= 9, month(OIS[10 Date Certified]) <=month(today()), output "Within 9 Months", and vice versa output "Longer than 9 months/Not certified yet"?
According to the documentation, if you need to perform an AND operation on multiple expressions, it is recommended that you use the AND operator ( &&) to join them all in a simpler expression.
You can try:
Condition Real Time =
IF (
OIS[Status] = "Certified"
&& OIS[MOnthCert] <= 9
&& MONTH ( OIS[10 Date Certified] ) <= MONTH ( TODAY () ),
"Within 9 Months",
"Longer than 9 months/Not certified yet"
)
Please refer to the following document for more information.
DAX AND OR IN or syntax(&& ||) – Which one? - The Excel Club
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for your reply.
But it seems not to be working
Hi @Vito ,
I'm sorry I can't understand your needs, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
No bother anymore, I think the issue is with the dataset itself of the pbix file. When I apply the same formula to the existing report on the RS or to the sample data, it works fine.
Thank you for helping anyway.
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 |
---|---|
109 | |
102 | |
84 | |
79 | |
70 |
User | Count |
---|---|
120 | |
110 | |
95 | |
82 | |
77 |