Forum Discussion

Yoshimitsu411's avatar
Yoshimitsu411
Resolver I
4 years ago

TotalYTD Based on Sum is Showing Incorrect Values

Hi All   I have the following measures:   UseRelationship is commented out because I didn't think it was necessary given the Quantities table is connected to the Date table indirectly via other t...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Yoshimitsu411 ,

 

It's hard to reproduce the scenario, can you share some sample data so that we could check the formula?

 

Best Regards,

Jay

Yoshimitsu411's avatar
Yoshimitsu411
Resolver I
4 years ago

Hi Anonymous 

 

In the screenshot below, I want to be create a running total by month without using TotalYTD or DatesYTD. 

TotalYTD and DatesYTD do no work due to the inactive relationship between my Fact table and Calendar table. So I need another way to sum the current month + previous month totals for each month.

 

This is my measure for RE column

RE = 
CALCULATE(
    SUM('Fact Table'[RE]),
      USERELATIONSHIP(
          'Fact Table'[Finish Date],
         'Calendar'[Date]
     )
)

 

 

The numbers I am hoping to see for RE Month Running Total are 

 

JAN - 1823.93
FEB - 3924.38
MAR - 6854.58
APR - 9485.38
MAY - 16197.27
JUN - 22117.43
JUL - 29069.76
AUG - 34472.28
SEP - 35423.93
OCT
NOV
DEC

 

Thank you.

 

Yoshi