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

Thanks. Investigating now....

edhans's avatar
edhans
Community Champion
6 years ago

Anonymous This is a subset of your model for just the HR and Budget tables.

 

What are you doing in the HR table, and how would you expect it to know which record(s) to get from the Budget table?

 

You cannot use RELATED with this kind of relationship. Not even sure if you can use RELATEDTABLE, though I'll have to investigate more.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    We have a unique 'Combo Key' in each table, I thought that it would be able to reference that