Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 97 | |
| 74 | |
| 50 | |
| 48 | |
| 46 |