Hi @Usates ,
There’s a major issue with the file you’ve provided because your model does not include a Date dimension table (the “Posting Period” does not meet the requirements for a valid date table). For your learning I strongly recommend you review all course material on that AND that you rework the Model yourself. You can find M code for several Date table types in the M code showcase category like the Extended Date table here.
Hi everyone,
To make it easier to find I’ve placed the updated Power Query M code function for the extended Date Table / Dates Table in the category where it belongs… I hope you’ll find it useful and if there are any questions, just reach out and let me know! follow this link) you can copy a version of Extended Date table which returns a r…
.https://forum.enterprisedna.co/t/why-you-must-have-a-date-table/4926
https://forum.enterprisedna.co/t/creating-the-ultimate-date-table-in-power-bi-how-to-do-this-fast-updated-code/10948
Hi @michellepace ,
In most cases when you have a date field in your model, you will want to do some time intelligence calculations and for that type of analysis this is indeed a requirement.
Below an excerpt of this Microsoft article
To work with Data Analysis Expressions (DAX) time intelligence functions , there’s a prerequisite model requirement: You must have at least one date table in your model. A date table is a table that meets the following requirements:
It must have a column of dat…
Hi everyone,
We’ve brought the Time Intelligence series we did for Enterprise DNA TV together in this post so it’ll be easier to find and navigate through completely. @BrianJ and I had great fun doing these. If you have any questions or concerns about the content covered in these video’s please create a new topic, refer to the video and @mention BrianJ or Melissa. But we’d also welcome your feedback within this thread of course. – THANK YOU –
How to create a Holiday table
[Ho…
Reach out if you need any assistance.
2 Likes