cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
abloor Member
Member

Relative date filtering UTC / revenue last month

Hi, my search has shown up that Relative Date filtering is based on UTC - for me this means the report doesn't tick over to the next day til 10am my time.

 

It looks like this hasn't been resolved by microsoft, but just wanted to see if anyone has any other ideas on a fix?

 

I'm trying to show the revenue we made for the last full month e.g. today being 1st October, I want to show the whole of September automatically, without having to choose the date in a slicer. I was using relative date filtering of last 1 calendar month, but as it doesn't tick over until 10am we have a few hours where the report will be wrong.

How would I do this as a measure? I have tried but can't get it to work.  I need to keep in mind that in January, I'd expect to see December show up.

Thank you!

2 REPLIES 2
Super User IV
Super User IV

Re: Relative date filtering UTC / revenue last month

Hi @abloor 

 

You can try applying the date dimension described in the blog post below, to make it work with your timezone you would have to offset the time in the Query editor and possibly create a dimension ( using dataflows ) for each timezone that your business is located. 

https://community.powerbi.com/t5/Community-Blog/Relative-Date-Dimension/ba-p/779039

 

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
Mariusz Repczynski

 

abloor Member
Member

Re: Relative date filtering UTC / revenue last month

Thanks very much @Mariusz I'll give it a try.

Helpful resources

Announcements
Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors