How to calculate Total Revenue

[michoolly15]

Hello All, Happy new month of April.

Kindly help with this problem.."what is the total revenue generated by each product category, and how does it compare to the previous year? "

[Jihwan_Kim · Accepted solution]

Hi,

I do not know how your semantic model looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file whether it suits your requirement.

OFFSET function (DAX) - DAX | Microsoft Learn

% diff previous year: =
VAR _currentsales = [Sales:]
VAR _prevsales =
    CALCULATE (
        [Sales:],
        OFFSET ( -1, ALL ( year_dim[year] ), ORDERBY ( year_dim[year], ASC ) )
    )
RETURN
    DIVIDE ( _currentsales - _prevsales, _prevsales )

[Uzi2019 · Accepted solution]

Hi @michoolly15 

Try below measure 

I have taken 2 level of data 
category > campaign type
so accordingly i have my measure. 
and for previous year comparison
previous year= calculate( [category sum], dateadd(date,-1,year))

I hope this reolves your issue!

[Jihwan_Kim · Accepted solution]

Hi,

I do not know how your semantic model looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file whether it suits your requirement.

OFFSET function (DAX) - DAX | Microsoft Learn

% diff previous year: =
VAR _currentsales = [Sales:]
VAR _prevsales =
    CALCULATE (
        [Sales:],
        OFFSET ( -1, ALL ( year_dim[year] ), ORDERBY ( year_dim[year], ASC ) )
    )
RETURN
    DIVIDE ( _currentsales - _prevsales, _prevsales )