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!

Dynamic Date Issue

Hello,

 

When trying to do a Month To Date report i am using Date Entered= to Current Month however, when there is a start to a new month, i do not get the total ofr the previous month its auto rolls into the next month. I.E. on 12/1 i would like to see the totals for 11/1-11/30. Is there a way to complete this so that when the report is published to the Services i dont have to manually adjust every month. 

 

TIA.

 

 

Status: Needs Info

Hi @mabbio 

 

Could you please provie some sample data or screenshots to make your issue more clear? 

 

Best Regards,

Community Support Team _Caiyun

Comments
v-cazheng-msft
Community Support
Status changed to: Needs Info

Hi @mabbio 

 

Could you please provie some sample data or screenshots to make your issue more clear? 

 

Best Regards,

Community Support Team _Caiyun

mabbio
New Member

Date.pngWhen I use this Relative Date its fine 12/1-12/31 but when the month switches on 1/1 it will restart the month but i would like to full month of December. This is a daily report with a MTD View so i just need that one day.