Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
There is 4 entries of each day but I want just first entry of that day.
Column - datatype
Date - date and time
Entry name - string
Count - no.
Better create a date column too
DT = datevalue([Date])
calculate(firstnonblankvalue(Table[Date], count(Table[Count no])), filter(allseleccted(Table) Table[DT] = max(Table[DT]) ) )
Power bi tutorial: DAX functions: lastnonblankvalue , firstnonblankvalue: https://www.youtube.com/watch?v=cN8AO3_vmlY&t=26940s
User | Count |
---|---|
13 | |
12 | |
8 | |
8 | |
6 |
User | Count |
---|---|
28 | |
19 | |
13 | |
11 | |
7 |