Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi friends
i have a table like this
Name | Date | Compare time | Check |
John | 01-07-20 5:00 | 01-07-20 18:00 | |
John | 01-07-20 10:00 | ||
John | 01-07-20 19:00 | John | |
John | 02-07-20 3:00 | John | |
John | 02-07-20 9:00 | 02-07-20 22:00 | |
John | 02-07-20 11:00 | ||
Ron | 03-07-20 14:00 | 04-07-20 3:00 | |
Ron | 03-07-20 17:00 | ||
Ron | 03-07-20 20:00 | ||
Ron | 03-07-20 21:00 | ||
Ron | 04-07-20 5:00 | Ron |
how i create the check column that will show name in its in case of date are after latest compare time indivisually
Solved! Go to Solution.
Hi @Anonymous ,
First go to query editor>add column>index column;
Then create a measure as below:
Measure =
var _maxcomparetime=CALCULATE(MAX('Table'[Compare time]),FILTER(ALL('Table'),'Table'[Name]=MAX('Table'[Name])&&'Table'[Index]<=MAX('Table'[Index])))
Return
IF(MAX('Table'[Date])>_maxcomparetime,MAX('Table'[Name]),BLANK())
Finally you will see:
For the related .pbix file,pls see attached.
Hi @Anonymous ,
First go to query editor>add column>index column;
Then create a measure as below:
Measure =
var _maxcomparetime=CALCULATE(MAX('Table'[Compare time]),FILTER(ALL('Table'),'Table'[Name]=MAX('Table'[Name])&&'Table'[Index]<=MAX('Table'[Index])))
Return
IF(MAX('Table'[Date])>_maxcomparetime,MAX('Table'[Name]),BLANK())
Finally you will see:
For the related .pbix file,pls see attached.
@v-kelly-msft thanks you so much and nice description, i will try your advices on my BI asap.
Hi @Anonymous ,
OK,if it helps solve the issue,could you pls mark the reply as answered to close it?😊
Much appreciated.
@Anonymous , Try a new column like
new colum =
var _date = maxx(filter(Table,Table,[Name] = earlier([Name]) && [date].date =earlier([date]).date),[Compare time])
return
if([Date]>_date, [Name], blank())
If earlier([date]).date do not work then have date column first
new date = [date].date
new colum =
var _date = maxx(filter(Table,Table,[Name] = earlier([Name]) && [new date] =earlier([new date])),[Compare time])
return
if([Date]>_date, [Name], blank())
thank for your solution but i have a little condition that if rows are shuffle and didnt sorted by date, what should i do? @amitchandak
@amitchandak in case of first row of compare time is blank, how you do adjusted DAX?
@Anonymous
try to fill down for comparedate column
then create a column
Column = if(Sheet12[Compare time]<='Sheet12'[Date ],Sheet12[Name],blank())
Proud to be a Super User!
thank you @ryan_mayu for your answer but is it possible to use only DAX?
because compare time are calulated column
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |