Forum Discussion
Dax column calculation
JCK2 - Yep!
First, Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Second, maybe:
Over due in the month = IF((MAX(' Audits'[Compliance Date])< MAX(' Audits'[Date Audit Performed]))|| ISBLANK(MAX(' Audits'[Date Audit Performed])) && MAX('SAM Supplier Audits'[Compliance Date])< TODAY(),1,0)
Thanks a lot Greg!! I am going to try this.
Greg, i used the calculation and when i dragged it into a table it works, but when i want to get a total, it does not seem to work
For eg: by month or by year, like an aggregated count, it does not seem to work. I think its because we are using the max calculation and what it does is calculate the over due on the latest date avaialable and showing the result as zero and not showing a count of all over dues.
Greg_Deckler I have now been able to create 2 columns
a) Audits Due
b) Audits Over due
Now i just want to create a calculation by creating a column
Audit Due-Overdue/Audits due to get the % completed on time.
However I am getting a circular dependcy error 😞
JCK2 OK, trying to come back up to speed on this, what are your formulas for the three columns?