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 20...
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")

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