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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Amaiap
New Member

Calculating COMP sales depending on Time slicer

Hello community! 

 

My knowledge of Power BI is very limited but I am trying to learn so I appreciate a lot your contributions in the forums and I would love to have your support for my request below:  

 

My report is built among others by two tables:

- one has the sales per business unit and date (columns: Unit, Date, Sales)

- one has the business unit with the opening and closing date of the unit (columns: Unit, OpeningDate, Closing Date)

I have a time filter with two date references: BoP (Beginning of Period) & EoP (End of Period).

I would like to view current sales vs LY but conditioned to COMP or NEW, understanding: 

COMP = totalize only sales of the units that were opened at least 1 year before the period referred in the time slicer and remained opened at least until the end of the period.

NEW = all the others

 

I don't know if I can create two measures COMP & NEW and use them as a slicer or if I need to create a calculated table with all the dates and COMP/NEW combinations. I would appreciate if you could guide me on the best possible way to do this, the more detailed answer, the better! 🙂 

 

Thanks a lot in advance. 

Regards,

Amaia

 

1 REPLY 1
Ashish_Mathur
Super User
Super User

Hi,

Share some data and show the expected result.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.