Forum Discussion

Thomas_Ramhapp's avatar
Thomas_Ramhapp
Regular Visitor
5 years ago
Solved

YoY Qty Measure

Hi everyone, Power BI newbie here, i created a visual with Partnumbers - Qty 2020, Qty 2019 - Total Qty (2020+2019). Now i just want to calculate the differnce of this both years. Not in YoY% but i...
Need Help
  • Thomas_Ramhapp's avatar
    Thomas_Ramhapp
    5 years ago

    tenfingers Anonymous amitchandak 

    Thanks Guys for your help. I found a very simple soloution from my problem.

    i mades some new basic measures.

     

    1. i summarized all the sales =SUM(TotalSales[Qty])

    2. Qty Last Year = CALCULATE(TotalSales[Qty], SAMEPERIODLASTYEAR (Date[Date]))

    3. Differnece from This year to Last year = IF( ISBLANK ([QtyLY]) , BLANK(), [TotalSales]-[QtyLY] )

     

    ā€ƒ

    result fits perfect for me.

     

    Thx again

    regards Tom

     

Thomas_Ramhapp's avatar
Thomas_Ramhapp
Regular Visitor
5 years ago

tenfingers Anonymous amitchandak 

Thanks Guys for your help. I found a very simple soloution from my problem.

i mades some new basic measures.

 

1. i summarized all the sales =SUM(TotalSales[Qty])

2. Qty Last Year = CALCULATE(TotalSales[Qty], SAMEPERIODLASTYEAR (Date[Date]))

3. Differnece from This year to Last year = IF( ISBLANK ([QtyLY]) , BLANK(), [TotalSales]-[QtyLY] )

 

ā€ƒ

result fits perfect for me.

 

Thx again

regards Tom

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

HI Thomas_Ramhapp,

Glad to hear you find and share the solution here, I think it should be helpful if someone else has faced a similar issue and try to find out the suggestions on power bi community.šŸ˜Š

Regards,

Xiaoxin Sheng