Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Conflict between Filter and Measure

Dear Powerbi Gods, My measure and new column/Filter is conflicting with each other.   I have 2 databases. Customer_database and Visit_database. They are linked by Customer and Customer Visited re...
Need Help
Show and Tell
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , Try like

    Days from Last Visit= IF(ISBLANK(max('Visit_Database'[Date of Visit])),0 ,DATEDIFF(Max('Visit_Database'[Date of Visit]),TODAY() ,DAY))

amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , Try like

Days from Last Visit= IF(ISBLANK(max('Visit_Database'[Date of Visit])),0 ,DATEDIFF(Max('Visit_Database'[Date of Visit]),TODAY() ,DAY))

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks amitchandak. Really appreciate your reply!!

 

I managed to solve the issue!!

I made the measure a calculated column instead and use the dax format as you provided but max date not working for me. But lastdate works for me.