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!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hi. I need to report on two metrics: the latest date in a table and one week prior to the latest date.
I successfully created a Latest Date column as such...
Solved! Go to Solution.
If this is another column in the same table, why not just use
Latest Date Week Ago = [Latest Date] - 7
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Well, that was easy! Thanks so much!
If this is another column in the same table, why not just use
Latest Date Week Ago = [Latest Date] - 7
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.