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
boyddt_mn
Helper III
Helper III

filter table by date and / or measure

I have a feeling that I'm missing something very simple but I am struggling with this.

I have the following tables and I need to filter for rows in the data that are the current 'ProdWeekYear'. The calendar file has the date and corresponding 'ProdWeekYear' and I've created a measure

ProdWeek = LOOKUPVALUE(JabilCalendar[ProdWeekYear], JabilCalendar[Date],"7/29/2021")
I was hoping to use this to filter the page but alas, cannot use measure to filter the page.
 
Here are the tables
DateProdWeekYear
7/12/20212021-28
7/13/20212021-28
7/14/20212021-28
7/15/20212021-28
7/16/20212021-28
7/17/20212021-28
7/18/20212021-28
7/19/20212021-29
7/20/20212021-29
7/21/20212021-29
7/22/20212021-29
7/23/20212021-29
7/24/20212021-29
7/25/20212021-29
7/26/20212021-30
7/27/20212021-30
7/28/20212021-30
7/29/20212021-30
7/30/20212021-30
7/31/20212021-30
8/1/20212021-30

 

Data

ProdWeekYearMRPMRP descDepartmentWeekly cMPS targetDaily cMPS targetMondayTuesdayWednesdayThursdayFridaySaturdaySundayWeekly actual shipmentRemaining volume
2021-28821Description 1Department 114.72.940000000014.7
2021-28822Description 2Department 200000000000
2021-28823Description 3Department 3290.558.1058542770003890
2021-28824Description 4Department 441.78.340000000041.7
2021-28833Description 5Department 5181.536.300906590007490
2021-29101Description 6Department 141125.448225.09105591119151601222243348192807471910
2021-29102Description 7Department 212.62.52012001200240
2021-29103Description 8Department 312663.752532.7516532539168229721183170223811969694.75
2021-29104Description 9Department 41714.25342.85247296100940386031480
2021-29105Description 10Department 54016803.2214322028560416955623342100
2021-30101Description 11Department 141125.448225.091417611678764510437271800466540
2021-30102Description 12Department 212.62.520000000012.6
2021-30103Description 13Department 312663.752532.754772043705296800061936470.75
2021-30104Description 14Department 41714.25342.85468169165152189001143571.25
2021-30105Description 15Department 54016803.2328831365787766003329687

 

Thank you in advance for any help offered.

 

 

1 ACCEPTED SOLUTION
ryan_mayu
Super User
Super User

@boyddt_mn 

maybe try to create a column in date and use that column to filter data

Column = 
VAR _ProdWeekYear=maxx(FILTER('Table (2)','Table (2)'[Date]=today()),'Table (2)'[ProdWeekYear])
return if(_ProdWeekYear='Table'[ProdWeekYear],"Yes")

pls see the attachment below





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

3 REPLIES 3
ryan_mayu
Super User
Super User

@boyddt_mn 

maybe try to create a column in date and use that column to filter data

Column = 
VAR _ProdWeekYear=maxx(FILTER('Table (2)','Table (2)'[Date]=today()),'Table (2)'[ProdWeekYear])
return if(_ProdWeekYear='Table'[ProdWeekYear],"Yes")

pls see the attachment below





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




That is exactly what I needed. Thank you for your quick response.

you are welcome





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




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.