Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only

Comparing Years Sales of same Customer Current year and PY

  • 1.  Comparing Years Sales of same Customer Current year and PY

    Posted Dec 11, 2022 02:26 AM

    Hi All,

    I have this problem:

    I should only compare customers who have sales in current year and previous year ( ineed the measure, no calculate column) are in DQ.

    I can't show the PY of customers who bought this year (Same Sales PY).

    PaoloCorrado_0-1670663654645.png

    PaoloCorrado_2-1670665155053.png

     

    PaoloCorrado_1-1670665092961.png

     

    This is the result I expect: If i filter year 2022 only customers A and B have sales in selected year and previous year.

    Name_Customers

    Basic_Sales Amount

    Basic_PY Sales Amount

    Same Sales Current Year

    Same Sales PY

    A

    980

    520

    980

    520

    B

    710

    950

    710

    950

    C

     

    460

       

    D

    440

         
     

    2130

    1930

    1690

    1470

     

    Download example pbix: (WeTransfer)

    Comparing Years Sales 

    Data:

    Date

    ID Cliente

    SalesAmount

    01/01/2021

    A

    100

    01/02/2021

    A

    150

    01/03/2021

    B

    250

    01/04/2021

    A

    50

    01/05/2021

    A

    120

    01/06/2021

    B

    300

    01/07/2021

    B

    250

    01/08/2021

    C

    100

    01/09/2021

    C

    160

    01/10/2021

    C

    200

    01/11/2021

    B

    150

    01/12/2021

    A

    100

    01/01/2022

    A

    600

    01/02/2022

    A

    280

    01/03/2022

    B

    200

    01/04/2022

    D

    30

    01/05/2022

    D

    80

    01/06/2022

    B

    110

    01/07/2022

    B

    250

    01/08/2022

    D

    80

    01/09/2022

    D

    140

    01/10/2022

    D

    110

    01/11/2022

    B

    150

    01/12/2022

    A

    100

     

    Any help or guidance would be amazing.

     

    Grazie!

    Paolo



    ------------------------------
    Paolo Corrado
    Business Intelligence Analyst presso Istante | Business Data Solutions | Azure
    Padova
    3.93E+11
    ------------------------------