Forum Discussion
Solved
Compare / Combine Data
Hello All, I have 2 tables - one has a list of locations, the 2nd has a list of locations, date of inspections, and scores of those inspections (Two different types of inspections) for each locat...
I revised the two measures below:
Audit Date 1 = IF ( MAX ( Table2[AuditScorePercentage1] ) <> BLANK (), MAX ( Table2[Date1] ) )Audit Date 2 = IF ( MAX ( Table2[AuditScorePercentage2] ) <> BLANK (), CALCULATE ( MAX ( Table2[Date1] ), Table2[AuditScorePercentage2] <> BLANK () ) )
See the link below. You may not need all these columns, so I would focus on what you want from your data model, and create those columns.
https://www.sqlbi.com/articles/reference-date-table-in-dax-and-power-bi/
Here's a link to a date table in Power Query:
https://radacad.com/all-in-one-script-to-create-date-dimension-in-power-bi-using-power-query
DataInsights Thank you very much for your time! Everything is working and I will use these links as reference.