Forum Discussion
DAX Calculation for Prior Period Date Range
mcornfield , prefer to have date table, "all" does not go fine when what do display row level data.
You can replace the date table with your table and check
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.
Thank you, the numbers look way high. I am wondering if it's not adhering to the slicers I have.
Any thoughts would be appreciated 🙂
Hi,
Share the link from where i can download your PBI file.
Hi,
You should ideally have a seperate Calendar Table with the Year and period columns appearing in the Calendar Table. We should then create a relationship between the Date column in your Table with the Date column in the Calendar Table. However the confusion at this stage would be that which Date column in your Table should be used for creating the relationship - QuestionEndDate or 2. Answer Date? Please clarify.
