TOTALYTD Fails to return a running total.

[Anonymous]

I've reviewed similar posts but I can't seem to find a solution to my specific problem with TOTALYTD not producing a running total. I have a simple fact table and date dimension (calendar table) joined with a one-to-many relationship. When I use the this forumla:

YTDRevenue = TOTALYTD(SUM(FactGeneralLedger[Revenue]), DimDate[Date])

I recieve this line chart using the DimDate[Date] column as the axis 

The formula is only reporting the sum of revenue by each month, not a running total as desired. I suspect the join but I can get the correct totals in SQL just fine. The tables are joined on a column called [DateKey] and then linked in the model. I then filter all items off DimDate[Date] which is a full DateTime stamp.

What do I need to change to achieve and actual running total?

[Greg_Deckler]

See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...

[Anonymous · Accepted solution]

Thanks for the reply Greg. I was pretty stubborn since what I'm trying to achieve (use my existing date table in the data warehouse) was very simple I figured there had to be a way. After a ton of heartache of formulas all not adding up I finally found the issue. I had to manually mark my Date Dimension table as a date table. Evidently PowerBI trys to guess these tables but since I used a Integer as my primary key, 20190212 for example, it could not parse it and I have to manually set it up as shown below:

https://docs.microsoft.com/en-us/power-bi/desktop-date-tables

If I run into issue in the future I"ll take a look at your formulas.