Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!View all the Fabric Data Days sessions on demand. View schedule
Hi,
I would like to change this function so it compares to the last 7 days instead of just today, is it somehow possible?
Here is the formula I want to tranform:
New? = IF([First Found Date]=TODAY(),"New", "Old")
Solved! Go to Solution.
@Anonymous , Like this ?
New? = IF([First Found Date]>=TODAY()-7,"New", "Old")
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!