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