Forum Discussion
Calendar Table is not slicing my data correctly
Hi,
Just to share how I solved the problem with my calendar table not filtering my data per date corretly. It was simple. I copy below the link where I found the solution.
https://radacad.com/how-to-use-time-and-date-dimensions-in-a-power-bi-model
Thanks
Correction:
when I say "that contain both date and time information (year, month, week, day hhmmss)."
I mean day, month, year hhmmss - 16/03/2020 11:07:13
- tamerj1
Community Champion
hi Iva_C_Maia
the date format does not seem to be the problem. You have two date tables. What are you trying to achieve exactly? Provide a sample of your data and explain the meaning of each date/column along with final expected results. Thank you
I have a large database of tests (1 ID_test per row), each test has a date/time for event1 (date column1 date) and a date/time for event2 (date column2).
I have 2 objetives:
1 - calculate the time difference betwwen event1 and event2 (this I have done, using a calculed column with datediff);
2 - create visuals where I see the distribution of tests per year, month, day, considering the date when event1 and/or event2 took place.
I hope this was clear. Thanks you for your help!
Hi,
Just to share how I solved the problem with my calendar table not filtering my data per date corretly. It was simple. I copy below the link where I found the solution.
https://radacad.com/how-to-use-time-and-date-dimensions-in-a-power-bi-model
Thanks
