Forum Discussion

evanj's avatar
evanj
Regular Visitor
8 years ago
Solved

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...
evanj's avatar
evanj
Regular Visitor
8 years ago

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])