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 in Power BI by vnk
• 310 points
129 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 by Gitika
• 33,770 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 272 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,070 points
155 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
• 51,890 points
125 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
• 51,890 points
96 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
174 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,460 points
116 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,460 points
1,993 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
216 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 in Power BI by Gitika
• 33,770 points
140 views
0 votes
1 answer

How do I install PowerBI on Ubuntu ?

Hi, @Bhagyashri, Based on my research, currently, it ...READ MORE

answered Apr 23 in Power BI by Gitika
• 33,770 points
2,127 views