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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
dexter2424
Helper I
Helper I

Get a value with date and product filters

Hi,

 

I'm new in Power BI, and I have tried so many functions, but none of them return me the right value. 

I have a table

ProductAmountStart Date
A10001-01-2019
B20001-01-2020
B25001-05-2019
C40015-03-2020

 

I would like to have the following:

SUM of the Product which are between 01-01-2019 and 01-01-2020, so A=100 , B =450, C is not in the list. 
After that I would like to divide the product sum with the Total sum of the products in the mentioned time range, so: 
100/550 and 450/550 what can gives me a percentage of the product distribution.

 

I have part success, but the hardest thing for me is divide it in a right time range.

 

Please help me, I would be appreciate!

Thanks,

D.

 

4 REPLIES 4
speedramps
Super User
Super User

Hi Dexter

 

Please consider this solution

 

Drag the date to a slicer visual

 

Drag the product and sum amount to a table visual

 

Now drag the amount to the table visual again.  So you have product, amount, amount.

 

Right click on the second amount and select Show value as > Percent of grand total.

 

Use the date slicer to select a date range and the totals and % should display accordingly.

 

 

 

 

 

Hi Speedramps,

 

Thanks for this solution, but this is only one step in my task, after this step I need to separate with another dates and additional products as well, that's why I need a measure or extra column to the dataset. 

 

Regards,

Dexter

Hi again Dexter

Hope you get a solution from someone.

Sorry I am struggling to understand the scenario. If you don’t get an answer then please elaborate on the exercise.

 

Yes, I have found thank you

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.