Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

If function not working

Hello all,   I am new to Power BI and I am trying to write an IF function in a column. I have two different tables that I need to pull data from. THe column needs to display "If the catagory on...
Need Help
  • sanalytics's avatar
    sanalytics
    6 years ago

    Hi Anonymous 
    As Greg_Deckler Suggested..
    you can try below formula..

    your col name=IF(HR[Category]="PBL",LOOKUPVALUE(Budget[Total Budgeted Base Salary],Budget[Combo Key],HR[Combo Key]),(HR[Annual Rate or max(Mid-Range Rate, Last Occupant Salary)]*HR[Funding Distribution]/100) )
     
    Hope it will solve your issue..

    Regards,
    snandy



edhans's avatar
edhans
Community Champion
6 years ago

Theoritically this should work

 

Test = 
SUMX(
    FILTER(
        ALL(Budget),
        Budget[Combo Key] = HR[Combo Key]
    ),
    Budget[Total Budgeted Base Salary]
)

 

but I'm not getting any hits. Are you sure those combo keys are the same? there are over 20,000 combo keys. Can you give me one that you are 100% sure is in both tables so I can test?

 

Oh, wait. I'm getting alot of hits, and a LOT of blanks. But that is working.

 

 

So you could replace your Budget[whatever that column was] with the above SUMX function.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

one example of a combo key I know for sure is in both tables is 

 

EE238847_00067707_D223730_F110_C10650