Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

MTD & QTD formula does not work when using time filter

Hi there, 

When using a MTD forumula, when I choose a prior and current time period, everything is fine, but when I go to 2023, unless I specifically go into trickle down to the exact month I am in with actual data, it gives me blank for MTD. 


The thing is I designed this report so it will continue to pop in 2023 data so the whole year is chosen. 

Many people use this report as is and I cant go in every new month and update it to reflect the new month simple to make those blanks dissapear nor do I want to instruct everyone to keep having to mess with the filter everymonth. 


Has anyone else encountered this issue.  Im using the typical MTD formula in powerbi called totalMTD. 




Super User
Super User

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Please show the expected outcome based on the sample data you provided.

Helpful resources

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors