Multiple dimensions, calculate TOTALMTD vs DATESMTD vs DATEADD

[F75]

Hi, I have data with multiple dimensions - company, cost center , product and scenario (Actual, Plan). I tried using function 

MTD = TOTALMTD(SUM(GLData[ActualAmount]),DimDate[Date])

and it does not seem to work. 

Here is the Table structure for GLdata and DimDate. Relationship is active between GLData[DateCal] and DimDate[Date].

In the report i have FiscalPeriod(Month) and next levell is Week#. What am i missing?

[Ashish_Mathur]

Hi,

Share the link from where i can download your file.

[F75]

Here it is. https://docs.google.com/spreadsheets/d/1pJ2P1aCMu0mptDl2xJIWHXF8G0dcNfk_ZcJbr18eRuU/edit?usp=sharing

I have week#, and i am using this to calculate DateCal.

Thanks

[Ashish_Mathur]

Hi,

Share the download link of the PBI desktop file, not the Excel file.

[Interkoubess]

Hi @F75,

Could you please share your data ( easy to manipulate) because with the printscreen it is not easy and I will make some try.

Thank you.

Ninter