Forum Discussion

KTP_UBS's avatar
KTP_UBS
Helper I
10 years ago
Solved

Adding new column IF statement in Query table

Hello,   I am relatively new to PowerBI and really appreciate it if you could help with my question below:   By referring to the excel screenshot below, I would like to add BudgetIndex2 and Budge...
Need Help
  • sdjensen's avatar
    sdjensen
    10 years ago

    KTP_UBS - did you solve your problem?

KTP_UBS's avatar
KTP_UBS
Helper I
10 years ago

Nope, it does not. I dragged the Project ID from the Project table in the sample file. The changes on the project ID slicer only affects the Total Grant not the Total Budget.

 

Thanks

sdjensen's avatar
sdjensen
Solution Sage
10 years ago

I made a few corrections to the file and it's working now - for some reason the relationship between the budget table and project table was deactivated. Try downloading the new file using the same link.

  • sdjensen's avatar
    sdjensen
    Solution Sage
    10 years ago

    KTP_UBS - did you solve your problem?

  • KTP_UBS's avatar
    KTP_UBS
    Helper I
    10 years ago

    Not particularly, I found another way in tweaking ways of how data is processed in the Query table. Anyway, thanks for the sample file. It is helpful for my next dashboard. Many thanks sdjensen.