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
385 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 389 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
371 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,290 points
181 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,290 points
138 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
350 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,910 points
189 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,910 points
3,118 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
278 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
581 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
2,744 views