Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Anonymous
Not applicable

Dax for calculating Sales volume for current/Last year for multi Timezone

I have to implement multitimezone functoinality for the sales volume current last year in powerbi

using clustered bar chart for the below scenario.

 

I have two tables one Date table and other Sales fact table with the below schema. 

Date                                      Sales

CaledarDate                          CreationDateTime

                                               Amount  

                                               TimeZone

                                               LocalTime

                                               Country

 

I have mapped CalendarDate with Sale table CreationDateTime. I have to add the clustered bar chart in powerbi which will show the currentyear/Last year sales comparison for last 12 months. 

Months should be calculated based on the time zone and the local time.

 

I have tried below dax  for last year sales volume : 

CALCULATE(SUM(Sales[Amount]),PARALLELPERIOD(Date[Date],-12,MONTH)) 

Its not working for the timezone. 

 

 

 

 

 

 

 

 

  

 

 

1 REPLY 1
Anonymous
Not applicable

Adding more information to this.

There is the Timezone filter in the report last 12 months should be calculated based on the timezone selected. we already getting timezone and localtime calculated from timezone in Sales table.

 

 

 

 

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.