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
920 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 605 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,570 points
599 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,350 points
324 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,350 points
245 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
536 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
• 33,010 points
308 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
• 33,010 points
4,698 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
457 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
1,733 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
13,859 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP