Forum Discussion

Marcegon's avatar
Marcegon
Icon for Helper II rankHelper II
2 years ago
Solved

Expression.Error: We cannot convert the value null to type Logical. Details: Value= Type=[Ty

Hi! I am new to the community and still learning Power BI.  Could someone help me fix this error?  I get null and error (see screenshot and rule below).  Any help would be appreciated.  Thank you! ...
Need Help
  • PijushRoy's avatar
    PijushRoy
    2 years ago

    Hi Marcegon 

    To make it simple, please create a separate custom column for. 
    Duration.Days(Date.From(DateTime.LocalNow())-Date.From([Start Date]))

    Please share a screenshot of your data or paste your data here (after removing sensitive information ) & full logic you want to implement.

    then use the column in your final custom column.

    Please let me know


PijushRoy's avatar
PijushRoy
Icon for Community Champion rankCommunity Champion
2 years ago

Hi Marcegon 

To make it simple, please create a separate custom column for. 
Duration.Days(Date.From(DateTime.LocalNow())-Date.From([Start Date]))

Please share a screenshot of your data or paste your data here (after removing sensitive information ) & full logic you want to implement.

then use the column in your final custom column.

Please let me know