Forum Discussion
DAX Calculation for Prior Period Date Range
Period Column is broken up into 2 month increments. I need to compare values vs the previous period and am not sure the DAX Formula. Below is what I have in PBI and then what I am looking to create. ...
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.
Period is based off of PeriodEndDate Thanks!
Hi,
That does not answer my question. I am sure someone else will help you with this.