Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
pmendoza
Frequent Visitor

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])

The problem I am having is that when I create a slicer to give me options for 2015 or 2016, I get blank results for current year, 2016, 

when I select 2015, data comes up.

There is data in 2016 in the sales table.

Clearly new to BI, and need some help.

Thanks

1 REPLY 1
fbrossard
Advocate V
Advocate V

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.