Forum Discussion

gianmarco's avatar
gianmarco
Helper IV
2 years ago
Solved

Revenues Last Year

Dear All,

I made a measure which is a calculate of sum of revenues with sameperiodlastyear, so it returns in a table visual the percentage of the revenues made by each client. If i filter by year 2023, this column shows the percentages regarding 2022.

The total is 100%, but I'd like it to show the difference between 2023 total revenues and the previous year total revenues.
How should I change the measure to reach this goal?

Thank you a lot

 

 

Need Help
  • bhanu_gautam's avatar
    bhanu_gautam
    2 years ago

    gianmarco , You can create a dax for this one

     

    RevenueAnalysis =
    VAR TotalRevenueCurrentYear = SUM('Sales'[Revenue])
    VAR TotalRevenuePreviousYear = CALCULATE(
    SUM('Sales'[Revenue]),
    SAMEPERIODLASTYEAR('Date'[Date])
    )
    VAR RevenueDifference = TotalRevenueCurrentYear - TotalRevenuePreviousYear
    VAR RevenuePercentageDifference =
    DIVIDE(
    RevenueDifference,
    TotalRevenuePreviousYear,
    0
    )
    RETURN
    "Current Year Revenue: " & FORMAT(TotalRevenueCurrentYear, "Currency") & " | " &
    "Previous Year Revenue: " & FORMAT(TotalRevenuePreviousYear, "Currency") & " | " &
    "Revenue Difference: " & FORMAT(RevenueDifference, "Currency") & " | " &
    "Revenue % Difference: " & FORMAT(RevenuePercentageDifference, "Percent")

2 Replies

  • rajendraongole1's avatar
    rajendraongole1
    Super User
    2 years ago

     

    I hope you have created lastyearpercentage measure and create below measures for revenue difference% to show the overall percentage difference between the selected year and the previous year.

     

    Create measure as :

    DifferencePercentage =
    VAR CurrentYearRevenue = [TotalRevenues]
    VAR LastYearRevenue = [PreviousYearRevenues]
    RETURN
    IF(
    ISBLANK(CurrentYearRevenue) || ISBLANK(LastYearRevenue),
    BLANK(),
    (CurrentYearRevenue - LastYearRevenue) / LastYearRevenue
    )

     

    Once create the above measure create this measure use it in a table chart

     

    ClientRevenuePercentageLastYear =
    VAR TotalRevenueLastYear = [PreviousYearRevenues]
    RETURN
    IF(
    ISBLANK(TotalRevenueLastYear),
    BLANK(),
    DIVIDE(
    CALCULATE(SUM(Sales[Revenue]), SAMEPERIODLASTYEAR(DateTable[Date])),
    TotalRevenueLastYear
    )
    )

     

    Try the above approach and let know

     

     

  • bhanu_gautam's avatar
    bhanu_gautam
    Super User
    2 years ago

    gianmarco , You can create a dax for this one

     

    RevenueAnalysis =
    VAR TotalRevenueCurrentYear = SUM('Sales'[Revenue])
    VAR TotalRevenuePreviousYear = CALCULATE(
    SUM('Sales'[Revenue]),
    SAMEPERIODLASTYEAR('Date'[Date])
    )
    VAR RevenueDifference = TotalRevenueCurrentYear - TotalRevenuePreviousYear
    VAR RevenuePercentageDifference =
    DIVIDE(
    RevenueDifference,
    TotalRevenuePreviousYear,
    0
    )
    RETURN
    "Current Year Revenue: " & FORMAT(TotalRevenueCurrentYear, "Currency") & " | " &
    "Previous Year Revenue: " & FORMAT(TotalRevenuePreviousYear, "Currency") & " | " &
    "Revenue Difference: " & FORMAT(RevenueDifference, "Currency") & " | " &
    "Revenue % Difference: " & FORMAT(RevenuePercentageDifference, "Percent")