cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
evanj Frequent Visitor
Frequent Visitor

half year vs previous half year

Hi, I am trying to compare 2018H1 vs 2017H1, 2017H2 vs 2016H2 etc (maybe 2018H1 vs 2017H2 also)

 

I have add a column to my date table with 2016H1, 2016H2, 2017H1, 2017H2, 2018H1 etc

 

I can then create a matrix with the year halfs and sales by various categories, but I can't figure out how to do a HY over HY comparison.  QTD vs PQTD I thought may work but could nto do so... please help

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-yuezhe-msft
Moderator

Re: half year vs previous half year

@evanj,

Please check the DAX in the PBIX file below.
https://1drv.ms/u/s!AhsotbnGu1NolAp9LEGTbG1v5r1m

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 REPLIES 4
evanj Frequent Visitor
Frequent Visitor

Re: half year vs previous half year

I did try the below, and it works for H1, but for H2 it has both H1 and H2 added together.

 

Sales Same Period Last year = CALCULATE([YTD Sales],SAMEPERIODLASTYEAR('Calendar'[Date]))

 

and then tried this, which works, except the equation above is wrong...

HoH = DIVIDE([Sales]-[Sales Same Period Last year],[Sales Same Period Last year])

 

for ref,  Sales = SUM(Sales[Ttl AMT])

 

Moderator v-yuezhe-msft
Moderator

Re: half year vs previous half year

@evanj,

Please check the DAX in the PBIX file below.
https://1drv.ms/u/s!AhsotbnGu1NolAp9LEGTbG1v5r1m

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
evanj Frequent Visitor
Frequent Visitor

Re: half year vs previous half year

thanks, looks promising, I will have to now go understand summarize by the looks Smiley Happy

Re: half year vs previous half year

Hi Lydia,

Could you please share this sample again? 

Apparently, the link to OneDrive is broken.

 

Many tkx !

 

Rolf