!!! URGENT !!! : Count User with last text column value

[kohlivinayak]

Hi Everyone

I have data like this

userid | skill  |  profeciency  |  date

1  |  Java  |  Low  |  Jan 1

1  |  Java  |  Medium  |  Jan 15

1  |  Java  |  High  |  Jan 30

2  |  PHP  |  Medium  |  Jan 10

2  |  PHP  |  High  |  Jan 15

1  |  PHP  |  Medium  |  Jan 10

1  |  PHP  |  High  |  Jan 15

In bar chart i want to show

skills on x-axis, count of user and last proficiency on legend

Lets say the selected date is 30th jan

so output should be

Java - high - 1

php - high - 2

Lets say the selected date is 15th jan

Java - medium - 1

php - high - 2

Lets say the selected date is 12th jan

Java - Low - 1

[Stachu]

Would this work:

CountUsers:=
VAR SelectedDate = LASTDATE('Table1'[date])
RETURN
CALCULATE(COUNTROWS(Table1),Table1[date]<=SelectedDate)

[kohlivinayak]

No this is still giving me same result

[Stachu]

is the 'date' field formatted as date type?

[kohlivinayak]

if you are getting the result can you share your pbix file?

[kohlivinayak]

Yes it is