Forum Discussion
mcornfield
Helper III
Helper IIIDAX 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. ...
mcornfieldHelper III
Helper IIIThank you, the numbers look way high. I am wondering if it's not adhering to the slicers I have.
Any thoughts would be appreciated 🙂
Ashish_Mathur
Super User
Super UserHi,
Share the link from where i can download your PBI file.
- mcornfield
- Ashish_Mathur
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.
- mcornfield
Period is based off of PeriodEndDate Thanks!