Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
TBoat
Frequent Visitor

Add Date Filter to Logic within Table - Earlier

Hi,

 

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 =
                maxx(filter(MonthlyFinancials,
                        MonthlyFinancials[da_Uid] = earlier(MonthlyFinancials[da2_Uid]) ),
                                    MonthlyFinancials[CostsSource])GM Saved.png

 

3 REPLIES 3
TBoat
Frequent Visitor

amitchandak
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!! 🙂

 

https://achillesanalytics15-my.sharepoint.com/:u:/g/personal/trevor_achilles-analytics_com/ERT1L5Erg...

 

GM Exp.png

 

 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.