Forum Discussion
Am I using ParallelPeriod right?
I'm differentiating between two time periods in my LOANHIST table- the current time period, and one month prior. When comparing the two, taking into account a bunch of different filters, we can tell...
PARALLELPERIOD is one of the sneaky ones. It returns the ENTIRE period, if you want it or not. Better use explicit DATEADD.
PARALLELPERIOD function (DAX) - DAX | Microsoft Learn
DATEADD needs continguous dates, which I don't have in my AccountingDate column.
Ah but you need to have a calendar table in your data model anyway 🙂
Hi,bonjourposte
Can you tell me if your problem is solved? If yes, please accept lbendlin's reply as solution.Best Regards,
Leroy Lu
Not yet. he had mentioned using DATEADD, but to use my date calendar instead of my list of dates in the table. I'm not entirely sure that's the solution at this point.