how to calculate month wise total count of session ids based start date

[vanir88]

Hi,

i have columns like [session Id], [start date], [finish date] so how to calculate below one

[G3S]

the measure would be the count of ID and the dimension for months would be 

MonthName([Start date])

[vanir88]

if i use above one im getting line chart like below.

[G3S]

just checking, did the MonthName([Start date]) not work for x axis?

[vanir88]

yes

[G3S · Accepted solution]

 would have  to get the month out of the [Start date] then bring that into the chart.  you would have to play around with the format/syntax of the field

[vanir88]

yes,  extracted  month and used in chart  but still it is coming like below.