Dax Calculations on Date time

0 votes
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.
Jun 18, 2020 in Power BI by vnk
• 390 points
523 views

1 answer to this question.

0 votes

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))

answered Jun 30, 2020 by Gitika
• 65,870 points

Related Questions In Power BI

+1 vote
1 answer

Need a DAX : To check the new escalations arrived, on the change of the escalation counter from zero to one or more

Yes exactly !  i need a measure for ...READ MORE

answered Sep 3, 2019 in Power BI by anonymous

edited Sep 3, 2019 437 views
0 votes
0 answers

DAX Calculations for dynamically changing value

2 requirements: please help below scenarios I HAVE ...READ MORE

Dec 3, 2019 in Power BI by anonymous
• 18,550 points
434 views
0 votes
1 answer

Group by columns on Power BI

On power BI desktop, do the following Add ...READ MORE

answered Sep 25, 2018 in Power BI by Kalgi
• 52,310 points
204 views
0 votes
1 answer

Display power bi report on my desktop application

Power BI has a new feature called ...READ MORE

answered Sep 27, 2018 in Power BI by Kalgi
• 52,310 points
160 views
+2 votes
0 answers

Assume referential integrity

1) What is Assume referential integrity? what ...READ MORE

Aug 19, 2019 in Power BI by vnk
401 views
+2 votes
1 answer

If Condition

DAX - I assume [Claim_line].[Allowed_Amount_B6] is one ...READ MORE

answered Aug 20, 2019 in Power BI by anonymous
• 32,930 points
204 views
+2 votes
1 answer

How to export data to CSV from power bi embedded url ?

Hi Arathi, You can open Visuals from embedded ...READ MORE

answered Aug 23, 2019 in Power BI by anonymous
• 32,930 points
3,491 views
+1 vote
1 answer

Power Bi to Machine Learning Model

Hello @vnk! Power BI only supports Azure Machine ...READ MORE

answered Dec 3, 2019 in Power BI by Priyanka
305 views
0 votes
1 answer

last 10 days data based on Date&time

Hi, @Vnk, Regarding your query, you have to ...READ MORE

answered Jun 4, 2020 in Power BI by Gitika
• 65,870 points
831 views
0 votes
1 answer

How do I count rows in one table based on values in another table using DAX?

If the tables are related, this is ...READ MORE

answered Sep 24, 2020 in Power BI by Gitika
• 65,870 points
5,214 views