Hi @SudipRoy1610 ,
According to your description, here are my steps you can follow as a solution.
(1) My test data is the same as yours.
(2) We can create a table.
Table 2 = SUMMARIZE('Table',[Date],"Total sales",SUM('Table'[Sales]))
(3) We can create a calculated column.
Total sales T-1 =
var _a=[Date]
var tmp=FILTER('Table 2',[Date]<_a)
var _b=MAXX(tmp,[Date])
return
CALCULATE(MAX([Total sales]),FILTER('Table 2',[Date]=_b))
(4) Then the result is as follows.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@SudipRoy1610 Thanks to the new visual calculations it can be very easily done. You can see the the steps below
In the image the data contains period from 6th May 2024 to 31st May 2024 from the main table. The data on the left is a calendar created out of the main table just like you mentioned but the earliest date is 1st of Jan 2024 rather than 6th May 2024 and the latest date is 31st Dec 2024 rather than 31st May 2024. This should not happen but not sure what that is the result.
Hi @SudipRoy1610 ,
According to your description, here are my steps you can follow as a solution.
(1) My test data is the same as yours.
(2) We can create a table.
Table 2 = SUMMARIZE('Table',[Date],"Total sales",SUM('Table'[Sales]))
(3) We can create a calculated column.
Total sales T-1 =
var _a=[Date]
var tmp=FILTER('Table 2',[Date]<_a)
var _b=MAXX(tmp,[Date])
return
CALCULATE(MAX([Total sales]),FILTER('Table 2',[Date]=_b))
(4) Then the result is as follows.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helpful resources
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
