Forum Discussion
Solved
DAX | Date Diff
Hello Team Need your help on the below I have 2 Tables, one includes Dates, Revised Due Date Second is a Calender table Used to define my Selected-Date=SelectedValue(Calender[Date]) Ne...
Hi Herchris7172 ,
Here are the steps you can follow：
1. Create measure.
Measure = var _select=SELECTEDVALUE('Calender'[Date]) var _if= IF( MAX('Table'[Revised Due Date]) = BLANK(), DATEDIFF( MAX('Table'[Date]),_select,DAY), DATEDIFF( MAX('Table'[Revised Due Date]),_select,DAY)) return DIVIDE(ABS(_if) ,30)2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi Herchris7172 ,
Here are the steps you can follow：
1. Create measure.
Measure =
var _select=SELECTEDVALUE('Calender'[Date])
var _if=
IF(
MAX('Table'[Revised Due Date]) = BLANK(),
DATEDIFF(
MAX('Table'[Date]),_select,DAY),
DATEDIFF(
MAX('Table'[Revised Due Date]),_select,DAY))
return
DIVIDE(ABS(_if) ,30)2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Another way I found out is this
_months_2 =
Var Due_Date = SELECTEDVALUE(Sheet1[Dates ])
Var Revise_Date = SELECTEDVALUE(Sheet1[Revised Due Date])
Var Results = IF(ISBLANK(Revise_Date), DATEDIFF(Sheet1[Selected-Date],Due_Date,MONTH),DATEDIFF(Sheet1[Selected-Date],Revise_Date,MONTH))
RETURN Results