Forum Discussion
inspection checklist cross reference
Hi there,
Based on your description all of this is very doable! What you want to achieve is maybe a bit too much to explain and write out for you in a single reply, however I would recommend you start with looking at some time intelligence articles (google Time Intelligence Power BI).
One thing you will definitely want is a Date dimension table - SQLBI's date table works just fine (https://www.sqlbi.com/tools/dax-date-template/)
There you can do calculations such as
Past_Inspection_Date =
IF(Today()-InspectionList[InspectionDate]>31,0,1)
From there you can SUM all the "1" results and visualise.
Regarding your point on historical data: This may be a case where you have to evaluate the structure of your dataset. Are you overwriting each date everytime an item is inspected? Or are you creating a new row for inspection? Although there is no true "correct" answer here, the latter is recommended as it will allow you to visualize historical trends, etc.
Hope this helps you with somewhere to start!
Thank you for your reply! A new row is added to the sharepoint list for each instance of an inspection. And I for sure have used SQLBI's date table. I'll start playing with your IF statement above.