Forum Discussion

wolfjnh's avatar
wolfjnh
Frequent Visitor
7 years ago

Filtering two dates in one table

Hi,   I have a table, where every row is representing a commitment. This table has following columns (simplified) * shipping_date * value * description * load_date (<- this leads to the fact, ...
Need Help
v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

Hi wolfjnh 

It's hard to provide the accurate solution without looking at sample data.Please check the attached sample file for reference and show me your simplified sample data to reproduce your scenario.

Regards,

wolfjnh's avatar
wolfjnh
Frequent Visitor
7 years ago

Hi v-cherch-msft ,

 

please find attached the pbix-file with all the measures and informations you will probably need.

The fake measures shows which values I would expect according to the slicer.

 

I had some issues with the english dateformat and changed it. Hope it works for you. 

 

pbix - Dropbox

Is there any possibility for me to upload directly to this page as you did it?

Regards,

Jan

  • v-cherch-msft's avatar
    v-cherch-msft
    Microsoft Employee
    7 years ago

    Hi wolfjnh 

    You may disconnect the relationship and use below measure:

    Measure (yours) =
VAR min_date =
    MIN ( 'Date'[Date] )
RETURN
    CALCULATE (
        SUM ( 'Table'[Value] ),
        FILTER ( 'Table', 'Table'[load_date] = min_date )
    )

    Regards,

    • wolfjnh's avatar
      wolfjnh
      Frequent Visitor
      7 years ago

      Hi v-cherch-msft ,

       

      thank you for your solution. To be honest, it is not the solution I need, but it is probably the nearest, we can get.

      I will think about the data schema again and maybe I can avoid this problem.

       

      Thank you for your time!