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 

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!