Forum Discussion
DAX Calculation for Prior Period Date Range
Thanks, So Everything is in one table. the columns I have are Date, Year, Month Period, Period Number, and # Acheived. SO I am not sure how to implement your suggestion.
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.
