Forum Discussion
Helper VAutomatic filter which value is based on comparison of two fields (or tables)
Hi,
I need to create a page which will show the latest updated data.
The table contains of raw data of every days transaction, like following
Date Category Value Last Update Date
1-Jan-18 A 100 6-Apr-18
1-Jan-18 B 110 6-Apr-18
2-Jan-18 A 200 6-Apr-18
2-Jan-18 B 150 6-Apr-18
..etc until 31-Dec-18
The value will be updated on respective date every day.
I'm wondering if I can apply a sort of automatic default filter to show the data on the last update date (date = last update date).
I'm looking for using a filter (visual/page)/slicer instead of another table filtered by this condition, since I'm thinking of provide the other date, so user still can select the other date.
Appreciate the help.
RMV,
Create a column using DAX below, then drag the column to visual level filters, set its value to 1 and check if you get expected result,Checkdate = IF(Table[Date]=Table[Last Update Date],1,0)
Regards,
Lydia
3 Replies
RMVBtw, I cannot use relative filter slicer and select "Last 1 day" filter as well. The value should be updated every day. But it may not be updated on the exact day as today. There could be a back dated/time gap.
RMV,
Create a column using DAX below, then drag the column to visual level filters, set its value to 1 and check if you get expected result,Checkdate = IF(Table[Date]=Table[Last Update Date],1,0)
Regards,
Lydia- RMV
Anonymous, thanks for the advise. i got the concept from what u suggested.
thanks for the help!