Forum Discussion
Trouble with date comparison
I am trying to write a measure that will calculate the number of business days in a given period of time. I have a date table that starts at 1/1/2019 and ends on 12/31/2020. Here is my measure:
2 Replies
Try
var EndDate = FORMAT (IF(MAX('Date'[Date])>TODAY()-1, TODAY()-1, MAX('Date'[Date]),"mm/dd/yyyy" )
Good luck!
msimmonsmcse , Create a column work day in you table
Work Date = if(WEEKDAY([Date],2)>=6,0,1)
If you are using slicer on the date of date table
Sum(Date[Work Date]) will give you that.
Refer 2nd page of this file how to use work day diff between two tables
https://www.dropbox.com/s/y47ah38sr157l7t/Order_delivery_date_diff.pbix?dl=0
Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.
