Forum Discussion

Michsara's avatar
Michsara
Regular Visitor
5 years ago
Solved

Latest text value - fixed on customer

Hi all   I'm very new to PowerBI and I'm trying to move my Tableau dashboards over, however I'm extremely stuck and none of the questions/answers on the forum have helped so far.   I need to add ...
  • amitchandak's avatar
    amitchandak
    5 years ago

    Michsara , Try like

     


    Last Contacted by = calculate(LASTNONBLANKVALUE('Table'[Date],MAX('Table'[Contacted By])),allexpect('Table','Table'[customer]))

     

    or


    Last Contacted by = calculate(LASTNONBLANKVALUE('Table'[Date],MAX('Table'[Contacted By])),filter(allselected('Table'),'Table'[customer] = max('Table'[customer])))

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Michsara , Try like

 


Last Contacted by = calculate(LASTNONBLANKVALUE('Table'[Date],MAX('Table'[Contacted By])),allexpect('Table','Table'[customer]))

 

or


Last Contacted by = calculate(LASTNONBLANKVALUE('Table'[Date],MAX('Table'[Contacted By])),filter(allselected('Table'),'Table'[customer] = max('Table'[customer])))

Michsara's avatar
Michsara
Regular Visitor
5 years ago

That's fantastic - the first option worked.  Thank you so much ğŸ˜Š