Forum Discussion
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.
1 Reply
- lbendlin
Super User
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523