dates in power bi

Question

How to see the visual from a set of time period from the indicated date through slicer?

Answer 1

Hi Raju,

You can show visual for a period of dates using slicer and dates functions.

1. Create a slicer with year or month or day(period type).

2. Using datesinperiod()

dates1 = DATESINPERIOD(Orders[Order Date].[Month],date,interval).

3. Using Datediff()

dates2 = DATEDIFF(date field1,datefield2,type)

Hope this helps.