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
emarome94
Helper I
Helper I

Sales that happene Prior Year but not This Year - Example Pic included

Hi everyone,

 

I have a simple model with a sales fact table and the various dimension such as Time/Data, Product, Customer, Country, etc. 

 

I would like to write a formula that retrieve the YTD of Prior Year Sales only when the condition where Sales YTD TY * Volume YTD TY = 0, so that for every value calculated this can be filtered, summarized by Country, Product, Customer, etc. 

 

Below a simple image that should give the idea: 

 

emarome94_0-1683628154457.png

 

 

I have tried a plenty of formulas but I did not have success: can anyone help me? 

 

 

2 REPLIES 2
emarome94
Helper I
Helper I

Anyone?

emarome94
Helper I
Helper I

Anyone?

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.