Forum Discussion

MIKAOKSA's avatar
MIKAOKSA
Helper I
6 years ago
Solved

Double date slicer (date table)

Hi,    I have a model with date table created with calendar auto and two different tables I want to filter with this date:   There is a relationship with REP_EMPORATWR_MV[END_ACTUAL] and Date...
Need Help
Tips and Tricks
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi MIKAOKSA 

    I don't know what should be the correct value for your visual.

    When looking into your data model, i find the [END_ACTUAL] is of datetime format, it is wrong to use this datetime column to relate the "date" table.

    You need to create a "date" column from [END_ACTUAL] in date format.

    You can also change the relationship among "REP_EMPOPERATWR_MV" and other tables to both, then check if it would show correct result.

     

    Best Regards

    Maggie

v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

Hi MIKAOKSA 

I don't know what should be the correct value for your visual.

When looking into your data model, i find the [END_ACTUAL] is of datetime format, it is wrong to use this datetime column to relate the "date" table.

You need to create a "date" column from [END_ACTUAL] in date format.

You can also change the relationship among "REP_EMPOPERATWR_MV" and other tables to both, then check if it would show correct result.

 

Best Regards

Maggie

MIKAOKSA's avatar
MIKAOKSA
Helper I
5 years ago

It took a long time but yeah, you are correct. Date-values from our ERP always come in a date/time format, so to filter them correctly I first need to make a new column with FORMAT and remove the time. After this filtering with these new values everything works just fine.

 

BR, 

Mika