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
CoreyP's avatar
CoreyP
Icon for Solution Sage rankSolution Sage
2 years ago

Oh, you created that as a calculated column. It needs to be a measure. Additionally, you need to set up a date dimension table in your model. The 'Dates'[Date] segment of my DAX function references the date table you need to set up. 

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.