Forum Discussion

Gaurav_84's avatar
Gaurav_84
Helper 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.

Gaurav_84's avatar
Gaurav_84
Helper I
1 year ago

Thanks jaineshp : can you please also suggest me how to calculate year to date Plan values. I tried using TOTALYTD formula but it didnt work.

for example if we are in month of august it should sum all the values till current month.

 

regards