• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Comparison of Filtered Start of Week / Month vs Previous filtered Start of week /filtered month

ShanShami

Member
Hello All,
I am working on a data set where I need to show Ticket Value variance as below...
Ticket Value = Revenue / Passenger

Visual 1
1. Filtered Start of Week vs previous week of Filtered Start of Week

Visual 2
1. Filtered Month vs previous month of Filtered Month

How can I create a measure for such scenarios.

Regards,
 
for example if I select 21Jan24 from Start of Week slicer then I wan to calculate the variance between 21JAn24 and 14Jan24.

1731499973004.png
 
Hi All,
I am trying to get the variance of sales vs last startofweek.
But I am getting result as infinity. May I seek your assistance.

I am writing below code to get the result.

Sales_LW = ([Total Sales]/ CALCULATE([Total Sales],
dates[Year]=SELECTEDVALUE(dates[Year])&&
dates[StartofWeek]=SELECTEDVALUE(dates[StartofWeek])-1))-1

where dates is a table and Year, Startofweek are columns - below codes for your information.
Year = Year([Date])
Startofweek= dates[Date]-WEEKDAY(dates[Date],3)


1732008427978.png


Regards,
Shan
 
Back
Top