Forum Discussion

Gaurav_84's avatar
Gaurav_84
Icon for Helper I rankHelper I
1 year ago
Solved

Variance calculation dex

Hi Experts,   Need your support in calculating variance using dex. Below is how my data look like.  Table 1 is the plan values for the whole year & table 2 is actual spent for the whole year. Maxi...
  • v-ssriganesh's avatar
    v-ssriganesh
    1 year ago

    Hello Gaurav_84,
    Thank you for reaching out to the Microsoft Fabric Community Forum.

    I have reproduced your scenario in Power BI Desktop and I got the expected output as per your requirement. The bar chart highlights the top 10 accounts with variance greater than 15%, and the table visual shows Plan YTD, Actual YTD, Variance Amount, and Variance %. Please find the attached .pbix file for your reference.

    Best Regards,
    Ganesh singamshetty.

v-ssriganesh's avatar
v-ssriganesh
Icon for Community Support rankCommunity Support
1 year ago

Hello Gaurav_84,
Thank you for reaching out to the Microsoft Fabric Community Forum.

I have reproduced your scenario in Power BI Desktop and I got the expected output as per your requirement. The bar chart highlights the top 10 accounts with variance greater than 15%, and the table visual shows Plan YTD, Actual YTD, Variance Amount, and Variance %. Please find the attached .pbix file for your reference.

Best Regards,
Ganesh singamshetty.