Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Add Date Filter to Logic within Table - Earlier



I am so close to getting the correct result I want.


Can I just put a filter on this to get the correct Associated Date @ Account #2 with the Cost Source in this Calculated Column?


Here is my Calculated Column. It has the Cost Source in the right rows, but just I need the correct Cost Source Data associated with that Account #2 and Date.


Thanks for the Help!



New column =
                        MonthlyFinancials[da_Uid] = earlier(MonthlyFinancials[da2_Uid]) ),
                                    MonthlyFinancials[CostsSource])GM Saved.png


Frequent Visitor

Super User
Super User

@TBoat , what is the date logic you want? As of neither it is sum or max.


The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

Hi @amitchandak Thanks for your help with this.


I watched your video and tried to create the calculated column like you did in the video and it gave me a circular error. I Think there has to be a filter with the Date or some other reference Account ID to get the correct Months data associated with that cost.


Here is a sample dataset. Hopefully you can help me find a solution to get the Sales & Costs lined up so I can get the Gross Margin % at the detailed Account Level. In this example I want the C/S Co 26'    Cost to be on the New-Co 263 line so I can get the % GM with that Associated sale. The 34.5% should be on the New-Co 263 Line. The Sales Line item data has that Account #2 which references the Cost line item I think this should be easy to reference?


Thanks again for all your Help!! 🙂


GM Exp.png



Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors