Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Nested SUMIFS column in PowerBI

Hi, I have a table that looks like this:   Date Code Value Adjusted value 01-01-2020 VAT 20 20 01-01-2020 Total short-term debt -100 -120 01-02-2020 VAT 100 100 01-02-202...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    6 years ago

    Anonymous 

    Please try to create a column

    Column = if('Table'[Code]="Total short-term debt",'Table'[Value]-sumx(FILTER('Table','Table'[Date]=EARLIER('Table'[Date])&&'Table'[Code]="VAT"),'Table'[Value]),'Table'[Value])

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
6 years ago

Anonymous 

Please try to create a column

Column = if('Table'[Code]="Total short-term debt",'Table'[Value]-sumx(FILTER('Table','Table'[Date]=EARLIER('Table'[Date])&&'Table'[Code]="VAT"),'Table'[Value]),'Table'[Value])

Anonymous's avatar
Anonymous
Not applicable
6 years ago
This one did the trick for my particular purpose. Thank you!