Forum Discussion
Month and week on same x axis
So I looking for a solution to have a period of months and weeks on the same axis. Example, show month Jan, Feb, Mar, but April didn't end and shows the weeks of the April until April is close an...
amitchandak
Super User
Super UserTmedeiros , Create a new column in Date table
if(month([Date]) < month(Today()), year([Date]) *100 + month([Date]) , year([Date]) *100 + weeknum([Date],2) )
You can create text column to using format and mark above as sort column
Good morning amitchandak ,
here a sample of the tables d_calendar and a f_transation. and a chart that I'm looking for to get the x axil with the period and weeks
thank you for the help