DAX command to automate expiry/next date and provide comments whether the next due date

[ebgumapas]

Hi Sirs/ Mam,

Requesting for assistance for a possible DAX command, that, when I enter columns "Last Inspection Date",

It will automatically provide expiry date under column "Next Due Date".

Likewise, remarks shall be provided whether the Due Date will be within 2 months Due, 1 Month Due and Overdue.

Will appreciate feedback and assistance regarding this matter.

Regards,

Von

[ebgumapas]

Thank you sir. Will revert once place.

[amitchandak]

@ebgumapas , Not very clear, But date diff can help

example, new column

=

var _diff=  datediff([due Date], today(), month)

return

Switch( True() ,

_diff <=1, "Due Within",

_diff =2, "Due in 2 month" ,

//Add others

Blank())

Switch-Case statement of #PowerBI: https://www.youtube.com/watch?v=gelJWktlR80&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=56