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



sanalytics's avatar
sanalytics
Super User
6 years ago

Hello all,

i am completly agree to edhans what he has tried to show.Sumx/Filter is much faster than LOOKUPVALUE.
I also believe that, one formula can achieve by multiple ways.
We the people who love to write Dax, some times we try to solve problem in own way that has been already solved.I have solved multiple problems which already Greg_Deckler  amitchandak edhans  Ashish_Mathur solved those problem before.Not looking for any kudos but definitely for learning to see how i can increase my skill.
Thanks to  edhans for showing a beautiful difference between LOOKUPVALUE vs SUMX/FILTER.

 

Regards,

snandy 

stay home,stay safe..

 

 

 

 



edhans's avatar
edhans
Community Champion
6 years ago

Thanks sanalytics - that is part of the fun with Power BI. It is like Excel - there are so many ways to arrive at the right answer, but fun trying to determine the best and fastest way.  Power on!