Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
RMV
Helper V
Helper V

Automatic 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.

1 ACCEPTED SOLUTION
v-yuezhe-msft
Employee
Employee

@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)

1.PNG2.PNG

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
v-yuezhe-msft
Employee
Employee

@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)

1.PNG2.PNG

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@v-yuezhe-msft, thanks for the advise. i got the concept from what u suggested.

thanks for the help!

RMV
Helper V
Helper V

Btw, 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. 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.