Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
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
otherwise blank
but my formula doesn't work,
it gives me blanks or today's date
reasons?
Solved! Go to Solution.
Hi @salman_ali ,
Refer to this:
next_date = var diff = DATEDIFF('Table'[date],TODAY(),DAY)
return IF(diff>=0&&diff<=7,TODAY()+diff,BLANK())
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @salman_ali ,
Refer to this:
next_date = var diff = DATEDIFF('Table'[date],TODAY(),DAY)
return IF(diff>=0&&diff<=7,TODAY()+diff,BLANK())
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@salman_ali , Seem like a new column like
Switch( True() ,
Query[Event Date] >= today() -7 && Query[Event Date] <=today() , today(),
blank()
)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |