Show difference of sales for various years.

[kanth123]

Hi 

Is it possible to have difference of sales between Years for current visual ? 

Sales are from Fact table.

Years and Month from Date table. 

Thanks,

Srikanth

[Daniel29195 · Accepted solution]

@kanth123 

create w measure as follow : 

measure = 

var current_year =  max(dimdate[year])

var prev_year =  current_year - 1

var current_year_calc =  sum(tbl_name[col_name])

var prev_year_calc = 

calculate ( 

sum(tbl_name[col_name]),

all(dimdate),

dimdate[year] = prev_year,

values(dimdate[month])

)
)

return 

current_year_calc - prev_year_calc 

let me know if it works for you .

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution !✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠

[Greg_Deckler]

@kanth123 Should be: Better Year Over Year Change - Microsoft Fabric Community

[kanth123]

Thanks for video. helped in creating optimized measures. 

[Daniel29195 · Accepted solution]

@kanth123 

create w measure as follow : 

measure = 

var current_year =  max(dimdate[year])

var prev_year =  current_year - 1

var current_year_calc =  sum(tbl_name[col_name])

var prev_year_calc = 

calculate ( 

sum(tbl_name[col_name]),

all(dimdate),

dimdate[year] = prev_year,

values(dimdate[month])

)
)

return 

current_year_calc - prev_year_calc 

let me know if it works for you .

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution !✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠

[kanth123]

This helps but not 100%,  when there are no sales in Current or Prior year it should be 0. 

[Daniel29195 · Accepted solution]

@kanth123 

you can just add a switch statement at the end, 

switch(

true() , 

current_sales = 0 ||  prev_sales = 0  , 0 ,  [your calculation]) 

let me know if you need any other help .