Forum Discussion
PARALLELPERIOD function when there's period missing
I'm using Parallelperiod to get previous value and it's working correctly for most except those that don't have value existed for certain period. For example if Company A has sales both in March and ...
Hi Anonymous ,
It is needed to create a Calendar table, and then create relationships between 'Details' table and 'Calendar' table.
Calendar = CALENDAR ( MIN ( Details[Report date] ), MAX ( Details[Report date] ) )Then, create your measure like so:
Measure 2 = CALCULATE ( SUM ( 'Details'[accrual] ), PARALLELPERIOD ( 'Calendar'[Date], -1, MONTH ) )BTW, .pbix file attached.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
It is needed to create a Calendar table, and then create relationships between 'Details' table and 'Calendar' table.
Calendar = CALENDAR ( MIN ( Details[Report date] ), MAX ( Details[Report date] ) )
Then, create your measure like so:
Measure 2 =
CALCULATE (
SUM ( 'Details'[accrual] ),
PARALLELPERIOD ( 'Calendar'[Date], -1, MONTH )
)
BTW, .pbix file attached.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.