Forum Discussion
Solved
Calculated column DAX
Hi There I have two calculated columns that show a 1 value for all dates that fall with a specified time period but I will like to change my calculations slightly to get a slightly different result. ...
(27/04/23-26/04/24)
pls try
=Var _StartDate = Edate(TODAY(),-12)+1Var _EndDate = TODAY()-1returnIF('CDCalendar'[CallDate]>=_StartDate && 'CDCalendar'[CallDate]<=_EndDate,1,0)(27/03/24-26/04/24)
pls try
=Var _StartDate = EDATE(TODAY(),-1)+1Var _EndDate = TODAY()-1returnIF('CDCalendar'[CallDate]>=_StartDate && 'CDCalendar'[CallDate]<=_EndDate,1,0)AnalyticsWizard Thanks for your reply, this worked with some minor tweaks only because I changed my mind on how many months I wanted to see, thanks for explaining it!
This works as well, thank you!
(27/04/23-26/04/24)
pls try
=
Var _StartDate = Edate(TODAY(),-12)+1
Var _EndDate = TODAY()-1
return
IF('CDCalendar'[CallDate]>=_StartDate && 'CDCalendar'[CallDate]<=_EndDate,1,0)
(27/03/24-26/04/24)
pls try
=
Var _StartDate = EDATE(TODAY(),-1)+1
Var _EndDate = TODAY()-1
return
IF('CDCalendar'[CallDate]>=_StartDate && 'CDCalendar'[CallDate]<=_EndDate,1,0)