How to create columns based on time created but in groups (This year, this month, last month)

[Lorentzt]

Hello.

Today i have a presentation of solution time (0-2,2-5,5-10 and more than 10 days) for tickets.

Each column is created by 4 measures. Like this for 2 Days: count2 = CALCULATE(counta('SO_TICKET'[2510D]),filter(all('SO_TICKET'[2510D]),'SO_TICKET'[2510D]=2))

Using the ticket created.date to show this in monthly or yearly columns:

 

We would like to change the presentation so the columns instead show:

• Current Month
• Last Month
• This year
• Last Year

Any sugestions on how to solve this would be welcome.

Possible solutions?

• Create one measure for each time periode using the original Measure and a date filter check.
• Create a column filter for this 4 periodes

How to do it though is the challenge

[BalaVenuGopal]

Hi @Lorentzt ,

you need to create 4 measures

 Curr Month = CALCULATE(counta('SO_TICKET'[2510D]),filter(your table name),Month(Your Date Colum) = Month(GetDate())

LIke wise you can create measures.

Hope this will resolve your isseu

Plese mark as solution if this works for you.

[Lorentzt]

Thanks for the help. I removed a ( and added a check for year (so i wouldnt get for that month in all years)

CurrYear = CALCULATE(counta('SO_TICKET'[2510D]),filter(SO_TICKET,YEAR(SO_TICKET[Created.Date]) = YEAR(TODAY())))

This gives me 238 that is the same ammount the 4 measures i have count up to if filtered on date for year :).

But how can i use this further?

Do i have to create 4 measures for each time periode as below? But then how do i manage to get that presented in 4 columns?

CurrMonthD2 = CALCULATE(counta('SO_TICKET'[2510D]),filter(SO_TICKET,Month(SO_TICKET[Created.Date]) = MONTH(TODAY())),SO_TICKET,YEAR(SO_TICKET[Created.Date]) = YEAR(TODAY()),SO_TICKET,SO_TICKET[2510D] = 2)