Forum Discussion
Month to date
I am using TOTALMTD function to get Month To date sum of sales in a Sales Table, which is related to my Dates Table via Date _Key.
MTD = TOTALMTD(SUM(SALES_Q_KRAMER[Amount_$]),Date_TBL[Date_KEY]) ...
Hi,
Which designer do you use (Excel or PowerBI Desktop) ?
Which data type do you use for your Date_Key ?
If you use Excel, make sure you have marked your Dim_Date as "Date table".
If you use PBI Desktop, make sure that you join your fact tables to your Dim_Date by using a date or a datetime column, because in PBI Dektop you cannot mark a table as date.