Forum Discussion
TiaCamilian
Resolver I
Resolver IReplacing months by numbers
Hi, I need to replace the Year-Month with a value like Month1, Month2 etc... I need to put __Total next 11 months and __Total 12 months back togeter I need the data in the following forma...
TiaCamilian
I guess the numbers are getting summarized. Just select the visual and right click on the __MonthNo1 field and select Don't summarize
nhowardResolver I
Resolver IAssuming that your field _Date11 is formatted as date, and that you are happy that Jan = 1 and Feb = 2
MonthNo = MONTH(LASTDATE(table[_Date11]))