Forum Discussion
Maps, Tables and Data
1. I would say use create table under Modelling tab option and use below code to get max values for datetime,
Table = FILTER(TABLENAME, TABLENAME[datetimeColumn] = MAX(TABLENAME[datetimeColumn]) )
2. Conditional formatting is only applicable for fields that are type numeric so you can't do something like parse string to find certain value 'Y' and show it in red. I don't think that level of formatting is possible currently.
3. You can have two image URL columns and create other calculated column with IF condition so show either url from URLColumn1 or URLColumn2 based on condition.
1. I would say use create table under Modelling tab option and use below code to get max values for datetime,
Table = FILTER(TABLENAME, TABLENAME[datetimeColumn] = MAX(TABLENAME[datetimeColumn]) )
2. Conditional formatting is only applicable for fields that are type numeric so you can't do something like parse string to find certain value 'Y' and show it in red. I don't think that level of formatting is possible currently.
3. You can have two image URL columns and create other calculated column with IF condition so show either url from URLColumn1 or URLColumn2 based on condition.
Hi ankitpatira,
Thank you very much for your help, i was able to filter the table and to transform my column in number. In the case of images, I will test and use in my next project.