Tuesday, 1 September 2020

DAX - Get the date difference in days from the slicer in Power BI

Hi All, 

 To get the date difference in days from the slicer in Power BI, follow below code


DAYSSELECTED =
VAR FirstDay = CALCULATE(
MIN('D_SALES_STATE_HIST'[DT_DOCUMENT]),
ALLSELECTED('D_SALES_STATE_HIST'[DT_DOCUMENT])
)
VAR LastDay = CALCULATE(
MAX('D_SALES_STATE_HIST'[DT_DOCUMENT]),
ALLSELECTED('D_SALES_STATE_HIST'[DT_DOCUMENT])
)
RETURN
DATEDIFF (FirstDay,LastDay,DAY)

No comments:

Post a Comment