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
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!