showing the current year excluding this month in a graph

[Anonymous]

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.

[devanshi]

VAR Currentmonth = FORMAT(TODAY(),"mmmm")

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

Month

[some_bih · Accepted solution]

Hi @Anonymous 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

[Anonymous]

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! 

[tamerj1]

@Anonymous 
Yes

[Anonymous]

Thank you 🙂