if date is 7 days ago, I would like to add 7 days to today's date
if date is 6 days ago, I would like to add 6 days to today's date
so on and so forth
if date is today, then leave it as is
but my formula doesn't work,
it gives me blanks or today's date
Go to Solution.
Hi @salman_ali ,
Refer to this:
next_date = var diff = DATEDIFF('Table'[date],TODAY(),DAY)
Best Regards,LiangIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
View solution in original post
@salman_ali , Seem like a new column like
Switch( True() ,Query[Event Date] >= today() -7 && Query[Event Date] <=today() , today(),blank())
Proud to be a Super User!
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.