Hi,
I have data table of three columns and need fourth column with results as it is shown in picture (column D). Tried lookupvalue, sumx but I don't have enough skills to do what I need. Any help please?
Hi @Edmundas ,
Please try this:
Result =
SUMX(
FILTER(
ALL('Table'),
'Table'[Date] =EARLIER ('Table'[Date])
&& 'Table'[Region] = EARLIER('Table'[Region])
),
'Table'[Ratio]
)
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Hi @Edmundas ,
Please try this:
Result =
SUMX(
FILTER(
ALL('Table'),
'Table'[Date] =EARLIER ('Table'[Date])
&& 'Table'[Region] = EARLIER('Table'[Region])
),
'Table'[Ratio]
)Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Helpful resources
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
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.
