Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
bdehning
Post Prodigy
Post Prodigy

I see 13 months on Visual

I have the following chart visual and today 3/1/23 I see this.  

 

13 months.PNG

What do I need to do to drop March 2022, since March 2023 has shown up?

1 ACCEPTED SOLUTION

I am still confused with this.  What is [Net]?    I am using my Date Column for [Date]

 

YTD Today =
var _min = eomonth(today(),-12)+1
var _max = today()
return
CALCULATE([Net], FILTER('Date','Date'[Date] >=_min && 'Date'[Date] <= _max))

View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User

@bdehning , You can use a relative date filter or slicer to show last 12 month

 

or can have measure like

 

YTD Today =
var _min = eomonth(today(),-12)+1
var _max = today()
return
CALCULATE([Net], FILTER('Date','Date'[Date] >=_min && 'Date'[Date] <= _max))

I am using a page filter right now that is set for Relative Date is in the last 1 years based on a Date Field and why I see two March Months 2022 and 2023. 

 

How do I use the measure you had me create to make it work

I am still confused with this.  What is [Net]?    I am using my Date Column for [Date]

 

YTD Today =
var _min = eomonth(today(),-12)+1
var _max = today()
return
CALCULATE([Net], FILTER('Date','Date'[Date] >=_min && 'Date'[Date] <= _max))

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.