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



Anonymous's avatar
Anonymous
Not applicable
6 years ago

When I try to to the "Related" function it does not give me the option to select anything from the budget table. How can I post the file for you to look at?

    • 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.