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

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.

      • sdjensen's avatar
        sdjensen
        Solution Sage
        10 years ago

        KTP_UBS - did you solve your problem?