cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Morth
Helper I
Helper I

showing the current year excluding this month in a graph

Good day to anyone reading this!

I am trying to find a way to display the dates in my date table to show the current year but exclude the current month. For example today it should show Jan, Feb, Mar & Apr excluding May. I've been looking around and playing with the filters but those don't seem to offer what I need so I would highly appreciate any help anyone can offer. 

Thank you in advance.

1 ACCEPTED SOLUTION
some_bih
Memorable Member
Memorable Member

Hi @Morth My practical approach: in your Date table create 2 columns

1. CurrentMonth: FORMAT(TODAY(),"mmmm")
2. This Month:  IF(CurrentMonth=FORMAT ( [Date], "mmmm" ),"Current Month",FORMAT ( [Date], "mmmm" ))
I hope this help
Sarajevo, Bosnia and Herzegovina

View solution in original post

5 REPLIES 5
devanshi
Helper V
Helper V

VAR Currentmonth = FORMAT(TODAY(),"mmmm")
 VAR Month =  IF(CurrentMonth=FORMAT ( [Date]"mmmm" ),Currentmonth-1,Currentmonth)
RETURN
Month
 
some_bih
Memorable Member
Memorable Member

Hi @Morth My practical approach: in your Date table create 2 columns

1. CurrentMonth: FORMAT(TODAY(),"mmmm")
2. This Month:  IF(CurrentMonth=FORMAT ( [Date], "mmmm" ),"Current Month",FORMAT ( [Date], "mmmm" ))
I hope this help
Sarajevo, Bosnia and Herzegovina

Hey there @some_bih,

This did help yes! thank you for that I just have one question left if you don't mind would this work still if I were to load in the data set for the next month again? 

Thank you in advance! 

@Morth 
Yes

Thank you 🙂

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors