Forum Discussion
Creating DateTime relationship, epoch time
Hi, I'm new to powerBI and I just pulled my historical weatherstation data from Azure to powerBI and now I'm trying to figure out how to make DateTime relation. Data was orginally organized by ep...
Hi Niko,
Could you please tell me if your problem was resolved? Could you please share the answer or mark the proper answer as solution if it's convenient for you? That will be a help to the others.
Best Regards!
Dale
Hi v-jiascu-msft
I've been busy with some other project but tried this trick today and it didn't work. I think this might work if I would do it in query mode (with M) not with DAX. Like I did the date and time table and then they started working. Is there someone reading this post who would know how to do this (TimeNoSec = FORMAT ( [Time]; "hh:mm:00" ) in M?
-Niko