Forum Discussion
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 ...
Thank you. I will read more on the filter context. If we don't use the filter to create a measure, I just could not find how to do subtraction between a measure (e.g. Prv QTR) and column (Current QTR). Can you please show an example how I might that work?
When I tried doing substraction without a measure for current QTR the new GAP measure didn't work. It said that you can't substract column and measure.
that's right, for the current quarter you would need to bring your own aggregation, like SUM(column). Like a measure does, but on the fly.
