Forum Discussion

Atlan's avatar
Atlan
Frequent Visitor
2 years ago
Solved

Problem with two Date columns

Hi, I use a query that produce a column with different time values (03.01.2022 09:48:44). In Power Bi I use the Preselected Slicer with a Date Table. In the Datetable all times 00:00:00. So I think ...
Need Help
  • sayaliredij's avatar
    sayaliredij
    2 years ago

    Hello Atlan 

     

    as i can not see all the settings and data completely, i have tried to prepare sample file using same fields like you (only necessary one) 

    DateFilters.pbix

    please download this and verify all the settings. 

    let me know if it helps. 

     

    Thanks,

    Sayali

sayaliredij's avatar
sayaliredij
Solution Sage
2 years ago

Hello Atlan 

 

as i can not see all the settings and data completely, i have tried to prepare sample file using same fields like you (only necessary one) 

DateFilters.pbix

please download this and verify all the settings. 

let me know if it helps. 

 

Thanks,

Sayali

Atlan's avatar
Atlan
Frequent Visitor
2 years ago

Hi sayaliredij ,

many thanks for your help with my problem. I tried the slicer with your Data. With this Data works the Preselect Slicer. So I watched again over my configuartion. The Date column had still the Time so the most values couldnt match and I got wrong values. I tried it with this:

newdate = FORMAT(Abfrage1[CreationDate]; "DD.MM.YYYY")
After I connect both date columns it works as expected.
Best Regards
Atlan