Forum Discussion
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
Are you looking for a calculated column or a measure? And what is the datatype of column1? If it's text, then I'd suggest you change it to a proper date(time) column and replace "unknown" with BLANK. Data types in Power BI are strict. It's not Excel.