Forum Discussion

PowerBi2bPro's avatar
PowerBi2bPro
Helper I
2 years ago

Help Needed - Troubleshooting Blank Column Values

Hi Everyone,   I am using this Function:   Prv_Qtr_Assets = CALCULATE(sum ('Income Statement $'[Average Assets]), DATEADD('Income$MasterDate'[Date].[Date],-1,QUARTER))   My goal was to create ...
lbendlin's avatar
lbendlin
Super User
2 years ago


Please show the expected outcome based on the sample data you provided.

PowerBi2bPro's avatar
PowerBi2bPro
Helper I
2 years ago

Thank you again. Here is a quick visual (done in PAINT) on what I am trying to get for an outcome. Not sure how to do it in Power BI.

 

 

Two Columns.

One for Current Year Asset Value and One for Previous Quarter Value

They should align in a way that at any given quarter I should be able to see both values side by side of what is current and waht was previous qtr.

 

My intention is to than substract current from previous to find the DELTA. 

 

When we plot the graph, it automatically adds SUM and double counts the already aggregated raw data values. as the current quarter values are aggrgated qtr over qtr.

 

Hope this helps adding some more context. Thank you for your time and help. 

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago
    One for Current Year Asset Value and One for Previous Quarter Value

    Did you mean "Current Quarter"  rather than "Current Year" ?

     

    My included PBIX has the "previous quarter"  measure - is that not sufficient?

    • PowerBi2bPro's avatar
      PowerBi2bPro
      Helper I
      2 years ago

      Sorry for any confusion. If you see the attached visual, you will notice that 2014 for the current and previous year table shows the same value. The image is from the PIBX that you shared. I just switched it to table format. I am not able to show the previous and current with different values. They are showing up as same. 

       

       

      What I want is the middle table but it should represnt valued for previous quarter in that column. 

       

      Link to the file: https://drive.google.com/file/d/1wwZJ7fpfImknqBdfDb0Yh0zQPUUnz6Kx/view?usp=sharing

       

      Thanks for the help