Forum Discussion

doubi1899's avatar
doubi1899
Regular Visitor
2 years ago
Solved

YOY calculation

For first column I use following code to calculate the total revenue of crruent month. It did work. "Current = TOTALMTD([total revenue],'IOSalesRecordbyCustomer'[Date])"   And second column I want...
Need Help
  • BeaBF's avatar
    BeaBF
    2 years ago

    doubi1899 I think I've identified the problem.
    1. Relate the Dates table to the Fact table via a many-to-one relationship, like this:

     

    2. Then Use Date field of Dates Table in the matrix, not the field of the fact table.

     

    Your measure will work.

     

     

     

    BBF

BeaBF's avatar
BeaBF
Icon for Super User rankSuper User
2 years ago

doubi1899 Hi! I'va sent you the request to access the file. 

Meanwhile, try with these formulas:

Current = TOTALMTD([Total Revenue], 'Dates'[Date])

YoY = CALCULATE(
SUM(IOSalesRecordbyCustomer[Total Revenue]),
SAMEPERIODLASTYEAR('Dates'[Date])
)

YoYComparison = [CurrentMonthRevenue] - [YoY]

 

BBF

doubi1899's avatar
doubi1899
Regular Visitor
2 years ago

approved the request.