Maintenance planner 52 weeks

Question

Hi all, hoping you can help , I'm wanting to create a 52 week maintenance planner .

the data I have says the task , the next due date, and the frequency it should come out

e.g. London st lighting checks - 1/8/23 - 1 weekly

id want to that task 52 times in a planner

london st kitchen check - 1/8/23 - 1 monthly

this would only show 12 times

hopefully that makes sense

foodd · Answer

Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot).

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.

Forum Discussion