Forum Discussion

sheenajose's avatar
sheenajose
Frequent Visitor
5 years ago

power bi date differences

Hi, how to achieve this in DAX  Date = IF('Table'[column1]="unknown","",today() - FORMAT('Table'[column1],"dd/mm/yyyy")) if the output is greater than 30 then value to be true else false
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

sheenajose , first of all clean up data in power query replace unknown with null. Change data type to date.

 

The you can do 

if(isblank('Table'[column1]), blank() , datediff(today(),'Table'[column1],day))

 

You can not work with composite datatype easily in dax. Better to clean up.