Forum Discussion

gianmarco's avatar
gianmarco
Icon for Helper IV rankHelper 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")

bhanu_gautam's avatar
bhanu_gautam
Icon for Super User rankSuper 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")