Forum Discussion

Starstorm's avatar
Starstorm
Frequent Visitor
4 years ago
Solved

Period-to-Period Variance(s) & Percentage(s) Without Hardcoding

Hi all, I am new here - great to be in this wonderful community.   I need help with showing the variances (in values & percentages) between periods in a matrix table for at least 24 months automati...
Need Help
Show and Tell
Tutorial Requests
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

Starstorm's avatar
Starstorm
Frequent Visitor
4 years ago

Bump

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
4 years ago

Hi,

I can try.  Share the download link of your PBI file.

  • Starstorm's avatar
    Starstorm
    Frequent Visitor
    4 years ago

    Thanks for reaching out. Apologies for the delay, here are the files.

    Please find the download link here: https://we.tl/t-K3XbSkReCw

     

    There are two files there:

    1. sample data.xlsx
    2. sample data.pbix

     

    I try to simulate the same process as what I intend to perform. Power Query at Excel first, then Power BI. I randomly generated amounts for assets, liabilities and equities for simplicity.

     

    Thanks for the help!