Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

@ Help Required

Need Help  - I have a dataset which holds [GroupName] (Indirect Cost, Direct Cost, Purchase, Sales Accounts,Miscellaneous Income,Stock PnL), [MMM_YYY], [Credit] and [Debit]. I want a single DAX Mea...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi Anonymous 

    Are the [Credit] and [Debit] in the same table?

    Which part is not sloved?

     

    Best Regards

    Maggie

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous 

Are the [Credit] and [Debit] in the same table?

Which part is not sloved?

 

Best Regards

Maggie

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Yes, am not able to crack this -
Stock PnL = Previous Month ([Credit]-[Debit]) - Current[Credit]-[Debit
  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous 

    Create measures

    c-d = SUM('Table'[Credit])-SUM('Table'[Debit])

stock1 = SUMX('Table',[c-d])

stock2 = CALCULATE([stock1],PREVIOUSMONTH('date'[Date]))-[stock1]

     

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.