DAX: Calculate parallel period value

Question

Hello,&nbsp;I have Sales Value from FactSales.&nbsp;&nbsp;I tried to calculated Sales Value 6 month ago based on Month slicer selection.&nbsp;My output table looks like,&nbsp;Let's say&nbsp;the selected month is Oct 2018&nbsp;ProductSales-Oct 2018Sales-May 2018&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Please assist me to achieve this.&nbsp;

v-cherch-msft · Answer

Hi&nbsp;SivaMani&nbsp;You may refer to below post to get the measure.https://community.powerbi.com/t5/Desktop/Date-slicer-and-parallelperiod-first-month-gets-corrupted/td-p/193756DAX formula compatibility in DirectQuery mode&nbsp;Regards,Cherie

Forum Discussion

DAX: Calculate parallel period value

1 Reply

Related content

Dynamic Calculation Different Period

Parallel Execution

calculate parallel period in columns

Current Period minus Parallel Previous period Percentage change calculation

Calculate period over period

Product	Sales-Oct 2018	Sales-May 2018