Forum Discussion

msimmonsmcse's avatar
msimmonsmcse
Icon for Helper I rankHelper I
5 years ago

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:   ...
MAX date
today
VNRaju's avatar
VNRaju
New Member
5 years ago

Try

 

var EndDate = FORMAT (IF(MAX('Date'[Date])>TODAY()-1, TODAY()-1, MAX('Date'[Date]),"mm/dd/yyyy" )

 

Good luck!