Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

mabbio

Dynamic Date Issue

Submitted by on ‎12-01-2021 08:05 AM

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

See more ideas labeled with:
2 Comments (2 New)
Comments
v-cazheng-msft
Community Support
Community Support
‎12-01-2021 06:19 PM
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
‎12-03-2021 10:30 AM

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. 

Idea Statuses