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
Anonymous
Not applicable

Target line based on criteria

Hi,

 

I have a pretty simple sales scenario, where products are sold on a date basis for a brand and in a region.

Next to that I have a table with targets for the combination of a month, brand and region.

 

I would like to present the sales per date or month with the target line.

The target line should be adjusted if I filter the data to only showing one or a few brands and one or a few regions.

 

I am not sure how to link up the data and make this happen. Who can help me with a simple demo or some instructions on how to approach this?

 

Many thanks in advance!

3 REPLIES 3
v-easonf-msft
Community Support
Community Support

Hi, @Anonymous 

Could you share your current sample file and expected result  for testing?


Best Regards,
Community Support Team _ Eason


negi007
Community Champion
Community Champion

@Anonymous 

Similar to your actuals, you can also have a target table where you will have target sales value for each product, each brand for each region. In the date column, you can have the first day of the month as a start date. In this way, you can use the date in the target table to arrive at monthly calculation. below could be the structure of the target table. You can link target table with date column and other product and region table as well

 

ProductBrandRegionTarget SaleDate
Prod 1Brand 1North2001-Jan-20
Prod 1Brand 2North1001-Jan-20
Prod 1Brand 3North3001-Jan-20
Prod 2Brand 1West3001-Jan-20
Prod 2Brand 2West2001-Jan-20
Prod 2Brand 3West1001-Jan-20
Prod 1Brand 1North2001-Feb-20
Prod 1Brand 2North1001-Feb-20
Prod 1Brand 3North3001-Feb-20
Prod 2Brand 1West3001-Feb-20
Prod 2Brand 2West2001-Feb-20
Prod 2Brand 3West1001-Feb-20

 




Did I answer your question? Mark my post as a solution!
Appreciate your Kudos



Proud to be a Super User!


Follow me on linkedin

Anonymous
Not applicable

@negi007 Not sure this will work 😞

I will basically have a many to many relationship now, right?

ie My brand3 will be many times in the fact table and many times in the target table....

Any ideas how to resolve?

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.