Forum Discussion
Eureka
Advocate I
Advocate IComparison vs last year on same perimeter
Hello, I want to create a metric to compare Sales Qty with last year but I want to remove the customers for which I have data for last year and not for this year. here is my table: Custo...
Eureka , Try a measure like
Diff =
Var _ytd = [ytd]
car _lytd = [LYTD]
return
sumX(Values(Table[Customer]), if(not(isblank(_ytd) ) && not(isblank(_lytd) ) , _ytd-_lyd, blank()) )
EurekaAdvocate I
Advocate IHello amitchandak ,
I have already tried those measures but it is not removing the quantity of the customer B in the volume. I want to remove customer B because this customer have no data for January 2022 and I dont want to take its volume to compare with January 2021.
I hope I express myself clearly,
Thank you
amitchandak
Super User
Super UserEureka , Try a measure like
Diff =
Var _ytd = [ytd]
car _lytd = [LYTD]
return
sumX(Values(Table[Customer]), if(not(isblank(_ytd) ) && not(isblank(_lytd) ) , _ytd-_lyd, blank()) )