Forum Discussion
Solved
Hour range on DirectQuery PBI
Hi experts, I have been trying to research around on how to perform a data transformation to my "time" field from fact table. There have been many forums talking about it, eg performing DAX but ...
jlhy , Either you need to create a timetable or bucket in your source database and use that (Join to this table)
or create time table in import mode
example of power bi import mode. you can join it with time column of direct query table too
https://kohera.be/blog/power-bi/how-to-create-a-time-table-in-power-bi-in-a-few-simple-steps/
jlhy , Either you need to create a timetable or bucket in your source database and use that (Join to this table)
or create time table in import mode
example of power bi import mode. you can join it with time column of direct query table too
https://kohera.be/blog/power-bi/how-to-create-a-time-table-in-power-bi-in-a-few-simple-steps/