Forum Discussion

Upali63's avatar
Upali63
Icon for Helper II rankHelper II
2 years ago

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...
Need Help
Upali63's avatar
Upali63
Icon for Helper II rankHelper II
2 years ago

Thanks

Did As you advised and below is the result

 

CoreyP's avatar
CoreyP
Icon for Solution Sage rankSolution Sage
2 years ago

Can you share a screenshot of the relationships in your model view? 

  • Upali63's avatar
    Upali63
    Icon for Helper II rankHelper II
    2 years ago

     

    • CoreyP's avatar
      CoreyP
      Icon for Solution Sage rankSolution Sage
      2 years ago

      Ohhh, I see what I did wrong. It's aggregating only for the date granularity, and not taking into account the account type. 

      • Upali63's avatar
        Upali63
        Icon for Helper II rankHelper II
        2 years ago

        Could you then share the correct measure that I should write  please. Thanks a lot

    • CoreyP's avatar
      CoreyP
      Icon for Solution Sage rankSolution Sage
      2 years ago

      For some reason this seems to work:

       

      • Upali63's avatar
        Upali63
        Icon for Helper II rankHelper II
        2 years ago

        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