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.
I may have ran into a bug with the DAX IF statement. The 2 expressions I used is:
Aging = DATEDIFF('table'[Date reported]; 'table'[Date changed]; DAY)
30 Days = IF('DataSource'[Aging] > 29; 1; 0)
Solved! Go to Solution.
Found out my problem and it was my mistake. Was due to a mixture 2-4 other columns and one of them being set to SUM rather than "Don't Summarize". Unfortunately I also couldn't reproduce it anymore either.
Found out my problem and it was my mistake. Was due to a mixture 2-4 other columns and one of them being set to SUM rather than "Don't Summarize". Unfortunately I also couldn't reproduce it anymore either.
@powerbiuser101,
It seems that you have solved this issue, please mark your reply as answer to close this thread.
Regards,
Lydia
Could you provide an example .pbix file with the issue to test it?
Thanks.
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 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |