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 ...
PowerBi2bPro's avatar
PowerBi2bPro
Helper I
2 years ago

Thank you that was very helpful. I wanted to than create DELTA using these two. I tried to use Current Assets but that did not work.

 

I than created a new measure.  

Current QTR = CALCULATE(sum ('Income Statement $'[Average Assets]), DATEADD('Income$MasterDate'[Date],-0,QUARTER))
 
Than use GAP as another measure to calculate DELTA. 
 
I think this might work well. If I wanted to show Cumulative for each year only what Measure calculation would look like?
 
Thank you 
Gap = [Current QTR]-[Prv_Qtr_Assets]
 
lbendlin's avatar
lbendlin
Super User
2 years ago

DATEADD -0  ?

 

Read about REMOVEFILTERS.

  • PowerBi2bPro's avatar
    PowerBi2bPro
    Helper I
    2 years ago

    Okay so the thing is that I want the current quarter as a measure so that I can create a new measure for the gap using the prev qtr measure that you recommended. 

    What is the best way to achieve this?  -0 did give the current qtr value in the measure. Based on your question, it seems that there may be a better way to achieve this. If possible, please share your thoughts. 

     

     

    • lbendlin's avatar
      lbendlin
      Super User
      2 years ago

      Yes, please read about the concept of filter context in Power BI.  For the current quarter you can (but don't need to) create a measure in the current filter context, without a need to specify additional filters.