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

doubi1899's avatar
doubi1899
Regular Visitor
2 years ago

approved the request.

BeaBF's avatar
BeaBF
Super User
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

  • doubi1899's avatar
    doubi1899
    Regular Visitor
    2 years ago

    thank you so much. I realized where the mistake is.