How to restrict data in a Table based on a Date dimension

[kaushi2020]

Hello Everyone,

I have a table where i have columns (All Dimensions only). I have a Act_Date field where we have data for each timestamp and date combination (Data is stored day wise).

I want to show only data for max(Ac_Date) in the table. 

Expectation is only data for highest date should be displayed. 

thanks in advance. @sunny_talwar 

[JonnyPoole]

You can do it a few ways but I would use 'conditional dimensional null filtering' to do this. 

1. On the Table, create a conditional expression that shows the data or null depending if the date is equivalent to the max date

=if(Date='$(vMaxDate)',Date)

2. This expression uses a variable  'vMaxDate' so you need to create a variable as follows:

3. And finally you need to disable nulls on the dimension in the table

They are optional, but I prefer to use variables with set analysis so try to improve the readability, stability and reuse of the app.