how to add today days to another date

[Anonymous]

how to add today days to another date

orderdate: 1st dec 2021 

today date: 8th dec 2021

Required output is 9th dec 2021

required dax

@amitchandak 

[amitchandak · Accepted solution]

@Anonymous , A new column

[Order Date] + day(Today())

a new measure

max(Table[Order Date]) + day(Today())

[Anonymous]

its working for me

[Anonymous]

@amitchandak  im trying to achieve this condition in power bi..

condition: 

// then If(([USAGE_DATE]<=Max(DateAdd("dd",Day(DateTimeNow()),[SelectedMonthYear]))) and ([USAGE_DATE]>=Max(DateAdd("mm",-5,DateTimeNow()))),"Y","N")

but max function cant access values instead of column..could you please help me on this how to achieve this statement If(([USAGE_DATE]<=Max(DateAdd("dd",Day(DateTimeNow()),[SelectedMonthYear]))) and ([USAGE_DATE]>=Max(DateAdd("mm",-5,DateTimeNow()))),"Y","N")

Power BI Dax: trying

_MeqY2 =

// then If(([USAGE_DATE]<=Max(DateAdd("dd",Day(DateTimeNow()),[SelectedMonthYear]))) and ([USAGE_DATE]>=Max(DateAdd("mm",-5,DateTimeNow()))),"Y","N")

var adddays = DAY(TODAY()) + [_SelectedMonthYear]

var last5 = DATE(YEAR(TODAY()), MONTH(TODAY())-5,1)

return

IF( 'Usage Tracking'[USAGE_DATE] <= MAX(adddays) && 'Usage Tracking'[USAGE_DATE] >= MAX(last5),1,0)