topic Re: Get a value with date and product filters in DAX Commands and Tips

Get a value with date and product filters

dexter2424 — Fri, 22 May 2020 10:03:42 GMT

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,

Re: Get a value with date and product filters

speedramps — Fri, 22 May 2020 10:21:11 GMT

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.

Re: Get a value with date and product filters

dexter2424 — Fri, 22 May 2020 10:35:23 GMT

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

Re: Get a value with date and product filters

speedramps — Fri, 22 May 2020 13:47:46 GMT

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.

Re: Get a value with date and product filters

dexter2424 — Thu, 28 May 2020 15:19:28 GMT

Yes, I have found thank you