Forum Discussion

adii's avatar
adii
Icon for Helper I rankHelper I
4 years ago
Solved

Measure to show values with filter based on date range

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's avatar
    Anonymous
    4 years ago

    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. 

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.