Forum Discussion

hidenseek9's avatar
hidenseek9
Post Patron
7 years ago

A help needed with structuring a table visual

Hello Power BI Community,   I need a help with structuring a table and to do a variance analysis on product performance. (PL tab specifically) Sample BI data   I would like the final table in P...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi hidenseek9

Currently, i have unpivot the "volume and Net Sales" columns, the create a measure

Measure = CALCULATE(SUM(Sheet2[Value]),FILTER(Sheet2,[DATE].[MonthNo]>=1&&[DATE].[MonthNo]<=3))

 

I will update my reply nextday.

 

Best Regards

Maggie

  • hidenseek9's avatar
    hidenseek9
    Post Patron
    7 years ago

    v-juanli-msft

     

    Thank you Maggie.

    I will wait for your response.

    It will be great to do a variance analysis.

     

    Thanks,

     

    H