Forum Discussion
Show only data from the latest date
Hi ChristianTD,
Seems date type values don't have a "TOP" filter type. I would suggest you try the measure below and add it to the "Visual Level filter". Don't need to add it to any visual. Then filter the filter as "1". Please give it a try.
Measure = VAR LatestDate = CALCULATE ( MAX ( 'Table1'[Date] ), ALL ( 'table1' ) ) RETURN IF ( MIN ( 'Table1'[Date] ) = LatestDate, 1, 0 )Best Regards,
Dale
Microsoft EmployeeHi ChristianTD,
Seems date type values don't have a "TOP" filter type. I would suggest you try the measure below and add it to the "Visual Level filter". Don't need to add it to any visual. Then filter the filter as "1". Please give it a try.
Measure =
VAR LatestDate =
CALCULATE ( MAX ( 'Table1'[Date] ), ALL ( 'table1' ) )
RETURN
IF ( MIN ( 'Table1'[Date] ) = LatestDate, 1, 0 )
Best Regards,
Dale
Hi everyone,
I have got some GSM datas with control date and hour.
In some situations, their tariffs plans are changed and when we report this table we see two plans for a number.
So I want to filter last day and last hour report in my table.
Here is my fake sample data. In this source of table we control available balance. So in Power BI we report Plan and Balance stiuations. So when i sort september value i have to see in this table just 4.09.2022 and 09:32 line.
| GSM Number | Tariff Plan | Available Balance | Date | Time |
| 53xxx56 | 20 GB | 10% | 2.09.2022 | 08:43 |
| 53xxx56 | 50 GB | 30% | 3.09.2022 | 10:40 |
| 53xxx56 | 100 GB | 90% | 3.09.2022 | 11:12 |
| 53xxx56 | 30 GB | 10% | 4.09.2022 | 08:30 |
| 53xxx56 | 60 GB | 70% | 4.09.2022 | 09:32 |
Thank you so much.