Dax Calculations on Date time

Question

I have a Datetime: 23/05/2020 11:15:10, We need to create a single filter/ Slicer based on Datetime.

1) Last 1 Hour 2) Last 4 hour 3) Last 8 hour 4) Last 24 hour 5) Last week 6) Last month 7) Last 30 days 8) Last 90 days

Using Slicer values are change in the power bi report.

How to create a dax calculation?

I need single slicer.

Answer 1

Hey, @Vnk,

I hope you have a data set where the dates will be contained. I am taking an example of "joining data" a heading over a table name  "employee_test":

FOR DAYS:

JoiningDay = Day( Table_name(JD))

For Months:

JoiningMonth = Month( Table_name(JD))

For Year

JoiningYear = Year(Table_name(JD))

For Hour

JoiningHour = Hour(Table_name(JD))