Forum Discussion
Upali63
2 years agoHelper II
Create New Column with Data from Same table
Hi Friends I have a data table as per sample below where the values in Amount Column alwayas show on accumulated basis as at end of each month. Now I want to create a new coloum subtracting curre...
CoreyP
2 years agoSolution Sage
Can you share a screenshot of the relationships in your model view?
Upali63
2 years agoHelper II
- CoreyP2 years agoSolution Sage
Ohhh, I see what I did wrong. It's aggregating only for the date granularity, and not taking into account the account type.
- Upali632 years agoHelper II
Could you then share the correct measure that I should write please. Thanks a lot
- CoreyP2 years agoSolution Sage
For some reason this seems to work:
- Upali632 years agoHelper II
It is working Thanks lot
It works only if I repalce Calender[Date] with Table (TB) [date]
If you dont mind can you help me to achieve same thing with a calculated column please