Forum

Mattias Jonsson
@matt-jonsson
Eminent Member
Joined: Aug 23, 2021
Topics: 11 / Replies: 14
Reply
RE: Match Latitude/Longitude positions with shape map - Climate zones

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

2 years ago
Topic
Forum
Replies: 1
Views: 154
Topic
3 years ago
Forum
Replies: 1
Views: 66
Reply
RE: Date dimension with year,month, day and hour

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...

3 years ago
Forum
Reply
RE: Date dimension with year,month, day and hour

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...

3 years ago
Forum
Topic
Forum
Replies: 2
Views: 85
Topic
Reply
RE: Convert dates

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, ...

3 years ago
Forum
Reply
RE: Lookup values, both day and time

Hej Anders! Tusen tack, var lite snabb där på fredagseftermiddagen och kollade mest ditt svar i formuläret. Vänligen Mattias

3 years ago
Reply
RE: Lookup values, both day and time

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 ...

3 years ago
Topic
Topic
3 years ago
Forum
Replies: 3
Views: 68
Reply
RE: Date and time table when not even numbers in time

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...

3 years ago
Forum
Reply
RE: Date and time table when not even numbers in time

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...

3 years ago
Forum
Page 1 / 2