Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Win a FREE 3 Day Ticket to FabCon Vienna. Apply now

Reply
Anonymous
Not applicable

how to add today days to another date

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 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Anonymous , A new column

 

[Order Date] + day(Today())

 

 

a new measure

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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User

@Anonymous , A new column

 

[Order Date] + day(Today())

 

 

a new measure

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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

its working for me

Anonymous
Not applicable

@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)
 
thimmaraju_0-1638976269145.png

 



 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.