Moving repeated values in last 3months

[Gokul_G16]

Hi Guys,

This is requesting to all,for the moving average concept.same we need find text character.when I select month in slicer I should see last 3month repeated candidate count like to expect matrix table..

I have tried dax some logical things.

Kindly leave it your thoughts.

Thanks 

Gokul

[Thennarasu_R]

@Gokul_G16
Hi,
Please Share Some Sample Datesets of your Requrirements

Thanks,
Thernnrasu 

[Jihwan_Kim]

Hi,

I am not sure how your datamodel looks like, but in my opinion, please try to start something like below.

- like moving avg, create a virtual table by using datesinperiod dax function (three months from the last date).

- show applications count per candidate in the virtual table that is created above

- filter out candidates who applied only once.

- count candidates

I hope this helps.

Thank you.

[Gokul_G16]

Hi jihwan,

I saw ur profile through LinkedIn

Please accept my request will discuss further 

Thanks

Gokul