Forum Discussion

harshad_barge's avatar
harshad_barge
Helper I
6 years ago
Solved

What am I doing wrong?

I am trying to update date in a column where the values are blank . The DAX is:   Position From (N) = IF ( ISBLANK ( [Position From Date] ), LOOKUPVALUE ( Fact_Position[Employee_ID], Fact_Po...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    6 years ago

    harshad_barge 

     

    Arguments <Result_ColumnName>, <Search_ColumnName> are in the wrong order.

amitchandak's avatar
amitchandak
Super User
6 years ago

Try as a new column. Share some sample data for lookup


new column in Fact_Position
Position From (N) = IF (
ISBLANK ( [Position From Date] ),maxx(filter('Ordinary Hours','Ordinary Hours'[Employee_ID]=Fact_Position[Employee_ID]),'Ordinary Hours'[Position From Date]),
[Position From Date])