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.

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

Hi,

You may download my PBI file from here.

Hope this helps.

  • Starstorm's avatar
    Starstorm
    Frequent Visitor
    4 years ago

    Thank you! It does show the variances respectively, and correctly. Is there a simplier way of doing? It looks so complicated. 🙂

     

    EDIT: By the way, are you able to provide me with some colors on how does the "Months to offset by" work?

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

      You are welcome.  I wish i knew of a simpler way to solve this.

  • Starstorm's avatar
    Starstorm
    Frequent Visitor
    4 years ago

    This confirms the MoM variance(s) are correct, but is there a way such that I just want the table to show, let's say February 2021 and March 2021; and it will only show their 2 values, with another table below for their variance?

     

    Thanks again.

     

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

      Hi,

      See the image below