topic Re: showing the current year excluding this month in a graph in DAX Commands and Tips

showing the current year excluding this month in a graph

Anonymous — Wed, 31 May 2023 07:50:04 GMT

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.

Re: showing the current year excluding this month in a graph

some_bih — Wed, 31 May 2023 08:13:14 GMT

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

Re: showing the current year excluding this month in a graph

Anonymous — Wed, 31 May 2023 08:38:54 GMT

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!

Re: showing the current year excluding this month in a graph

tamerj1 — Wed, 31 May 2023 09:02:58 GMT

Anonymous
Yes

Re: showing the current year excluding this month in a graph

devanshi — Wed, 31 May 2023 09:10:23 GMT

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

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

Month

Re: showing the current year excluding this month in a graph

Anonymous — Wed, 31 May 2023 09:31:29 GMT

Thank you 🙂