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?

sdjensen's avatar
sdjensen
Solution Sage
10 years ago

Try adding the project id from the project id table instead of the one from the budget table - The one in the budget table should be hidden in the model since it's only used to create a relationship from the budget table to the project id table.

KTP_UBS's avatar
KTP_UBS
Helper I
10 years ago

Thanks. Could you please advise on how to write a If statement that compare rows values in the Query Editor? 

  • sdjensen's avatar
    sdjensen
    Solution Sage
    10 years ago

    I am not sure how to compare data from 2 different rows, but why do you need that? Does my sample not 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.