Forum Discussion

Gautier's avatar
Gautier
Frequent Visitor
9 years ago

Variable to store interval for the parallelperiod function

Hi All,   I have a complex bridge formulat that dinamically compares the sales of the selected period with either the previous month, quarter or year depending on the selection.   For instance is...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Gautier,

When using PARALLELPERIOD function, we are not able to store interval parameter in a variable.  The value for interval in PARALLELPERIOD Function (DAX) must be one of the following: year, quarter, month.

In your scenario, you would need to use the original DAX formulas to dynamically compare the sales of the selected period.


Thanks,
Lydia Zhang