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

Hello,

 

Thanks for the sample file.

 

It works in a way if I pull out the Total Grant and Total Budget from two data sources / tables.

 

Could you please advise if I would like to add a slicer of Project ID so that when I select a project I could see the total grant and total budget for that particular project?

 

Please see screenshot for your reference. I don't think I can attach the PB file here in the forum :(

 

 

Thanks.

 

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