Same Day Last Year measure not appearing in chart

[Anonymous]

Hello,

So my data is kwh consumption per day for various buildings in a perio of 2 years. What i need to visualise is kwh consumption compared to the same weekday last year (the closest one for the same month).

So i have used DAX measures to get those. For Kwh same day last year i used:

Kwh LY to Day=CALCULATE([Total Kwh], FILTER(ALL('Date'),'Date'[DWY]=MAX('Date'[DWY])-1))

 And for the variation i used:

 LY to Day Kwh Var = 'Electricity Consumption 19/20'[Total Kwh]-[Kwh LY to Day]. I also did the % with: 

LY to Day Kwh % Var = DIVIDE([LY to Day Kwh Var], [Kwh LY to Day])

So i got all the corecct numbers and used them in a table, slicing it by year.

When i try to move those to a line chart though i either can't get them to show or i get the wrong numbers (kwh last year to day is the same as kwh this year)

Can anyone help??

Thanks 🙂

[amitchandak]

Same weekday is 364 days behind

Same week day Year behind Sales = CALCULATE([Total Kwh],dateadd('Date'[Date],-364,DAY))
Year behind Sales = CALCULATE([Total Kwh],dateadd('Date'[Date],-1,Year))

[Anonymous]

@amitchandak thanks for the measure now it works better in the sense that both 

Same week day Year behind Sales

and kwh appear in the chart. But the line value for same weekday last year is in the beginning of the chart that has the older dates and the columns are at the end with this year's dates.

What i need is for the columns to show this year dates and the line value to show same weekday last year. When i try to filter by date then the line with the last year to date measure diasapears completely.

Any idea on how to get the visual i need with the measure you gave me, this year kwh and the date in a line chart?

[v-xuding-msft]

Hi @Anonymous ,

Can you please share some sample data and a few screenshots? Then we will understand clearly.

[Anonymous]

@v-xuding-msft 

I have this chart with Kwh for 2020 and 2019. I have a measure that shows Kwh same day last year (the orange one) and a value that shows kwh this year (the blue columns). I want to show them together in my visual so the report can show the difference between this year and same weekday last year. For some reason thought they are shown separetely and i don't know how to connect them.

Unfortunately i can't share any of the data i have, hope the screenshot helps.