Forum Discussion

PowerBi2bPro's avatar
PowerBi2bPro
Icon for Helper I rankHelper 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
Icon for Super User rankSuper 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
Icon for Helper I rankHelper 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