Measure to show values with filter based on date range

[adii]

Hello , I'm totally new here , so Hello everyone 🙂 

Please help me with some problem which I got. 

I would like to create measure which show me result suche as below.

I tried to use Calculate(Values(Table1,[Product]),FILTER(Table2,[DATE] = DATESBETWEEN([Table2, [Start_date],[End_date])

but its wrong wrote. 

BTW I tried either use Calculate(Values(Table1,[Product]),FILTER(Table1,[Start_date] = DATE(2022/10/1) i recived BASE_M_10 but its not exacly what I want.

Generally I would like create Measure which in result show me product for every day from table 2

Thanks a lot 🙂 

[Anonymous · Accepted solution]

Hi @adii ,

According to your description, you want to show values with filter based on date range, right? Here are my steps you can follow as a solution.

(1)We can create  a measure.

Measure = var _date = SELECTEDVALUE('Table2'[Date])

var _t =DISTINCT( SELECTCOLUMNS( FILTER(ALL('Table1') , 'Table1'[Start_date] <= _date && 'Table1'[End_date] >= _date) ,"product",[Product]))

return

_t

(2) Then the result is as follows.

…

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

Best Regards,

Neeko Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[amitchandak]

@adii ,the Datebetween return a table

so option are

Calculate(Count(Table1[Product]), DATESBETWEEN([Table2, [Start_date],[End_date]))

Calculate(Count(Table1[Product]),FILTER(Table2,[DATE] in DATESBETWEEN([Table2, [Start_date],[End_date]) )

But refer to my blog for your problem

https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-o...