9 Replies Latest reply on Sep 17, 2018 7:38 AM by Shinichiro Murakami

# MQT and countd

Hi everybody,

I'd like to count how many ID i've in MQT for each month. Unfortunately, as you can see in my attached file, I obtain the sum of each month. Any solution for having the good result ?

Many thanks,

Mélanie

• ###### 1. Re: MQT and countd

Hi Mélanie

Do you want this?

you can also use an LOD -> {FIXED DATEPART('month',[Date Fact]): COUNTD([ID])}

• ###### 2. Re: MQT and countd

What is MQT?, what is the expected value for each month's cell?

Thanks,

Shin

• ###### 3. Re: MQT and countd

Hi,

sorry, MQT = Moving Quarter Total --> Cumulative 3 last months.

So; for Feb, I should have 11, for March, 12.

Many thanks !!

Mélanie

• ###### 4. Re: MQT and countd

Hope this helps.

My observation says 5,8,12 not 11 for Feb anyways,

Thanks,

Shin

• ###### 5. Re: MQT and countd

Just following up.

If you think problem is solved, please mark my answer as correct / helped to close the thread not from inbox but from originals post.

Thanks,

Shin

• ###### 6. Re: MQT and countd

Hi,

sorry for my late reply, but it seems it doesn't work ! The result for Feb is 11 !

Many thanks for your help !

kind regards,

Mélanie

• ###### 7. Re: MQT and countd

I understand, I was thinking it was Q to Month, but actually moving three months.

Then the solution is below.

If you think problem is solved, please mark my answer as correct / helped to close the thread not from inbox but from originals post.

Thanks,

Shin

• ###### 8. Re: MQT and countd

Many many many (*1 000 000) thanks ! It's work !!!!

King regards,

Mélanie

• ###### 9. Re: MQT and countd

You are welcome.

Shin