Hi, Thanks for trying! Yeah, it's not easy and I was afraid I would get that answer but it was worth a try! BR Mattias
Hi, Yes, that's clarifies that I should round my time in the fact table, and add Fiscal year to my date table, thank you. But where should I con...
Hello, I'm restarting this topic, since I need to use some DAX functions with Time intelligence. I'm having problem with where to connect the da...
Hi, Thank you. I got that working in Power BI, by adding a "1" as day, and them formatting is YYYY-MM. Is there any way to do that in Power Query, ...
Hej Anders! Tusen tack, var lite snabb där på fredagseftermiddagen och kollade mest ditt svar i formuläret. Vänligen Mattias
Tack Anders! I just made an example to explain what I want, so I hadn't spent any time on the formatting. What I need help with is how to write the ...
Hello again, That last tip takes away the empty rows. But for some reason it rounds down in a strange way twice a day. That adds five time ste...
Thank you both! I tried the Power query formula and it works for most values. I added a column called "Rounded timestep". Then I merged the two col...