Forum Discussion

samdep's avatar
samdep
Icon for Advocate II rankAdvocate II
4 years ago

TOTALMTD in Measure without a Relative Date Filter? Stumped!

Hi PBI Community,   I am stumped on this one, so would appreciate any and all tips! I was successfully able to create a YTD measure and it works without overlaying any sort of date filter, relative...
samdep's avatar
samdep
Icon for Advocate II rankAdvocate II
4 years ago

Update - I tried using the date field in my fact table with TOTALMTD and it worked, so I just need to figure out why YTD works with my Calendar table, but not MTD and QTD. If anyone has any guidance, I'd be very appreciative - otherwise, I was able to achieve the needed calculation by bypassing my Calendar table. Thanks all!