Forum Discussion

Jaromir's avatar
Jaromir
Frequent Visitor
9 years ago
Solved

Memory issue - IF using calculated measure

Hi,   I am trying to calculate a day by day difference in stock values. To do that I have created a calculated measure called PrevStock:   PrevStock = CALCULATE(SUM('data'[stock]); PREVIOUSDAY('d...
Need Help
  • CahabaData's avatar
    CahabaData
    9 years ago

    You might consider approaching it in the data model as follows:

    * make a duplicate table T2

    * in T2 make a calculated column that is (date less 1): PriorDate

     

    Now join your Table to T2 using T1 date field and T2 PriorDate; or possibly even consider a merged table of the two - - kind of thinking out loud here....

     

    * to avoid confusion in field names of T1 and T2 together you might change column name of T2 Stock to PriorStock

     

    via Related method (or possibly the merged table) now you have Stock and Prior Stock in the same record and getting the difference is at your finger tips

CahabaData's avatar
CahabaData
Memorable Member
9 years ago

You might consider approaching it in the data model as follows:

* make a duplicate table T2

* in T2 make a calculated column that is (date less 1): PriorDate

 

Now join your Table to T2 using T1 date field and T2 PriorDate; or possibly even consider a merged table of the two - - kind of thinking out loud here....

 

* to avoid confusion in field names of T1 and T2 together you might change column name of T2 Stock to PriorStock

 

via Related method (or possibly the merged table) now you have Stock and Prior Stock in the same record and getting the difference is at your finger tips