Forum Discussion
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 in my specific scenario, I am using a DirectQuery approach to perform a transformation but it kept saying that this kind of change is not supported in DirectQuery.
Eg, I have timings like 11:43:00 am, 12:10:00 pm, 12:11:00pm.
I would like to have it class by 1100 - 1200, 1200 - 1300
If I can only use DirectQuery method instead of import, how can I achieve this?
Sorry if this has been asked before but I just can't find one yet. Appreciate if anyone could guide me to the right path.. thanks!
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/
1 Reply
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/