TOTALYTD not creating cumulative total

[Anonymous]

I am struggling to get TOTALYTD to give me a cumulative total.

I've tried creating the measure 4 different ways, but always get a result that looks like it's not using the date as part of the context at all.

[VasTg]

@Anonymous 

Update:

Just noticed the formula. Could you try change the columns into Date format instead of datetime?

Also, where is the date column "Rowlabels" come from? Is that the same column as Calendar[Date]?

Did you try TOTALYTD(SUM(brand_dashboard_facts[gms]),'Calendar'[Date])

If this helps, mark it as a solution.

Kudos are nice too.

[Anonymous]

Thanks for your help.

>Just noticed the formula. Could you try change the columns into Date format instead of datetime

Not sure how to do that.  Is this what you mean?

[Anonymous]

Regarding your question about the "row lables" - that is the reg_yrmo_as_fdom column, which is the date column that is mapped to the Calendar table.

[VasTg]

@Anonymous 

Try using the date from calendar table instead of fact. 

Hope it should work.