I love the report from Data Mentor that @mspanic did. Its powerfully tool that EDNA team has working on to help us.
Did you try an AI tool like Data Mentor or ChatGPT to help you?
Attaching a proper phix file with SAMPLE Data within would definitely help people of the forum where you are getting stuck. Maybe your structure on how your file is setup.
Just from the coding the following questions I would have:
-
Are you using the EDNA Date Table? Here is the link to it that @Melissa have created for the forum to use. Extended Date Table (Power Query M function) - Power Query / M Code Showcase - Enterprise DNA Forum
-
Do you have the Date Table marked as Date Table.
-
I wouldn’t do any kind of hard coding within your DAX of dates but instead use a two date slicer and reference that date slicer (beginning slicer and Ending date slicer). You would have to change the coding every time if you want a different kind of period.
-
Here is a video that @BrianJ did for the forum to help mask Sensitive Data that you can provide the forum with with a PHIX file.
TIP: Tools and Techniques for Providing PBIX Files with Your Forum Questions - Forum Guides - Enterprise DNA Forum
I hope this helps.
thanks
Keith