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
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
Hi Iva_C_Maia ,
Glad to hear you have solved your problem. Please mark the reply as a solution. More people will benefit from it.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.