Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Dear Friends i need a small help
How to write a DAX
Start date : 7/10/2019 (MMDDYY)
End Date : 8/6/2019 (MMDDYY)
i need a minimum Date of end date output : 8/1/2019
i want to calculate difference dates b/W 8/6/2019 minmum of end date i.e 8/1/2019
DATEDIFF(minmum of end date i.e 8/1/2019, end date i.e 8/6/2019, day)
Thanks
Godasu
Solved! Go to Solution.
Hi @Anonymous ,
You may try to create measures like DAX below.
DateDiff= DAY(LASTDATE(Table1[Date]))-1
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
I think You need this:
DayDiff = var _maxDate = MAX(time[dates]) RETURN DATEDIFF( DATE(YEAR(_maxDate);MONTH(_maxDate);1); MAX(time[dates]); DAY )
Hi @Anonymous ,
Does that make sense? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.
Best regards
Amy
Hi,
I think You need this:
DayDiff = var _maxDate = MAX(time[dates]) RETURN DATEDIFF( DATE(YEAR(_maxDate);MONTH(_maxDate);1); MAX(time[dates]); DAY )
Hi @Anonymous ,
You may try to create measures like DAX below.
DateDiff= DAY(LASTDATE(Table1[Date]))-1
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
The requirement is not clear.
Can you upload sampledata,pbix and output expected to Google/OneDrive and share the link here to find the right solution.
Cheers
CheenuSing
User | Count |
---|---|
127 | |
108 | |
100 | |
63 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |