Get a value with date and product filters

[dexter2424]

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

Product	Amount	Start Date
A	100	01-01-2019
B	200	01-01-2020
B	250	01-05-2019
C	400	15-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.

[speedramps]

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.

[dexter2424]

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

[speedramps]

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.

[dexter2424]

Yes, I have found thank you