maxdate

6 Topics

MAXDATE
Does the function MAXDATE work in Power BI and, if so, why not?
Solved
Anonymous
3 years ago Place DAX Commands and Tips
1.3KViews
0likes
1Comment
get MIN, MAX DATE then count duration in hour
hi all; i have data set, https://docs.google.com/spreadsheets/d/159xOcmrKj95YXYOayHmGi9A_K_8ZHIMq/edit?usp=sharing&ouid=100079262241875009342&rtpof=true&sd=true the point is; i already get MIN DATE, and MAX DATE ( with Measurement); but then how to get duration(hour) from that ? i tried using DATEDIFF formula but the result is wrong . First Started = CALCULATE ( MIN ( 'Data'[DateStarted] ), ALLEXCEPT ( 'Data', Data[DateCreate], Data[worker] ) ) Last Finished = CALCULATE ( MAX ( 'Data'[DateFinished ), ALLEXCEPT ( 'Data', Data[DateCreate], Data[worker] ) ) duration(hour)= datediff([Last Finished] , [First Started],HOUR) thank you for your help; Azura
Solved
bikgx
3 years ago Place DAX Commands and Tips
1.5KViews
0likes
4Comments
Find Next Most Recent Date Dynamically
Hi, I'm struggling to find a solution in the forum for what I'm trying to accomplish, with that being said thank you and I appreciate any/all help to the resolution to (or guidance to a similar situation that may help resolve) my issue. I have a table similar to below PJB_ID Created_By Created_Date 1111 [email protected] 1/13/22 1112 [email protected] 2/21/22 1113 [email protected] 3/17/22 1114 [email protected] 2/5/22 1115 [email protected] 1/29/22 1116 [email protected] 4/5/22 1117 [email protected] 2/22/22 1118 [email protected] 3/24/22 The first thing I want to do is have a visual (table) that displays the most current PJB_ID the individual created something like this: PJB_ID Created_By Created_Date (most recent) 1117 [email protected] 2/22/22 1116 [email protected] 4/5/22 1118 [email protected] 3/24/22 Then if I have a date slicer and someone selects a date that is prior to the (most recent) created date, it will display the next most recent. So the table then would look like this if 2/1/22 was selected from the slicer: PJB_ID Created_By Created_Date 1115 [email protected] 1/29/22 1111 [email protected] 1/13/22 null [email protected] null I've tried to use the max, last date, and a few other functions but can't seem to get it to work the way I want. I apologize if this type of issue has been resolved already and if it has and someone can shoot me a link to the post, I'd greatly appreciate it. Thanks for giving this a look and helping. Regards, Cody
Solved
Anonymous
4 years ago Place DAX Commands and Tips
1.2KViews
0likes
6Comments
Max Date joined to itself
I basically have a table that has a date column, I am trying to find the max date for each row and then join this table to itslef on the query Table1[date] joined with Table1[MaxDate] So that I can remove duplicates/dedup them. How do I do that?
Solved
MORDax
4 years ago Place DAX Commands and Tips
1.3KViews
0likes
6Comments
Can't get the recent Date Values
Hi there, I am trying to get the recent date value for the table below. I have tried the max and lastdate function but I cant seem to get the results i am expecting. I was able to get a seperate latest effective date column with Measure = Calculate(MAX(Table(Effective_Date), Allexcept(Table, table(id)) Table: ID Emp_ID Interval Effective_Date Score 1 1001 0 01/01/2020 3.1 2 1001 0 08/26/2020 3.3 3 1001 3 11/20/2020 3.5 4 1001 5 05/05/2020 3.2 5 1001 5 2/1/2021 4.1 6 1002 0 1/1/2022 2.0 Expected result if i want to see the recent date values if i filter by interval 0. ID Emp_ID Effective_Date Score 2 1001 8/26/2020 3.3 6 1002 1/1/2022 2.0 or if i dont filter any of the intervals i should get all client IDs with a recent date value witht their corresponding intervals. ID Emp_ID Interval Effective_Date Score 2 1001 0 8/26/2020 3.3 6 1002 0 1/1/2022 2.0 3 1001 3 11/20/2020 3.5 5 1001 5 2/1/2021 4.1
Solved
yve214
4 years ago Place DAX Commands and Tips
2.9KViews
0likes
11Comments
Last Sale Date by Sku
Hi! I am fairly new to Power BI and need help finding the last sale date of a sku. I've tried with the following: Date = CALCULATE(max(SOP30200_SalesHeader[DOCDATE]),ALLSELECTED(IV00101_ItemMaster[ITEMNMBR])) but this brings back the last date of sale as yesterday for everything (the last time refreshed). Can someone point me in the right direction? This will help me for other reports I'm building as well. Thank you in advance! Steph
Anonymous
5 years ago Place DAX Commands and Tips
1.1KViews
0likes
4Comments