Dynamic Counter

[Noak]

Hi Guys,

I would like to create a dynamic counter.

I have licence plate column & Date column.

I would like to count for each licence Plate how many times it apperas in my data set (by selected period) .

thank you!.

LP       date

111     1.1.17

222     2.1.17

111     2.1.17

111     3.1.17

https://ibb.co/nNDvqw

[Greg_Deckler]

Just do a COUNT on "date" column.

[Noak]

Hey @Greg_Deckler I decided not to do that.

I prefer to count num for iteration for each Licence plate in my data set any ideas?

[Eric_Zhang]

---

@Noak wrote:

Hey @Greg_Deckler I decided not to do that.

I prefer to count num for iteration for each Licence plate in my data set any ideas?

---

@Noak

A measure counting rows shall work, see the attached pbix file. If this is not your case, please post more sample data and expected output.

cnt = COUNTROWS(yourTable)

[Noak]

Tnx @Eric_Zhang

I would like to have the ability to fillter by occurrences. 

any tips/tricks (based on countrows massuare, here I created a static counting column and the date isn''t dynamic)?