Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Multiple dates in one table vs Date Table

Hi All,    I have created a DATE table for my powerBi reports. I have another table where I have Create_date and Close_date. I create relationship with Date table to my Close_date and wanted to see...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , check there is no timestamp in created on. You change data type to timestamp and have format to show time and check it

 

You can create date if need

created date = datevalue([Created on])

 

Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4

measure using  Userelation will also filter on the same selected date

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    amitchandak  - Checked, not working. See the screenshots below - 

     

     

    My CreatePipe numbers are in millions.