Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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
Date | ProdWeekYear |
7/12/2021 | 2021-28 |
7/13/2021 | 2021-28 |
7/14/2021 | 2021-28 |
7/15/2021 | 2021-28 |
7/16/2021 | 2021-28 |
7/17/2021 | 2021-28 |
7/18/2021 | 2021-28 |
7/19/2021 | 2021-29 |
7/20/2021 | 2021-29 |
7/21/2021 | 2021-29 |
7/22/2021 | 2021-29 |
7/23/2021 | 2021-29 |
7/24/2021 | 2021-29 |
7/25/2021 | 2021-29 |
7/26/2021 | 2021-30 |
7/27/2021 | 2021-30 |
7/28/2021 | 2021-30 |
7/29/2021 | 2021-30 |
7/30/2021 | 2021-30 |
7/31/2021 | 2021-30 |
8/1/2021 | 2021-30 |
Data
ProdWeekYear | MRP | MRP desc | Department | Weekly cMPS target | Daily cMPS target | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Weekly actual shipment | Remaining volume |
2021-28 | 821 | Description 1 | Department 1 | 14.7 | 2.94 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 14.7 |
2021-28 | 822 | Description 2 | Department 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
2021-28 | 823 | Description 3 | Department 3 | 290.5 | 58.1 | 0 | 58 | 54 | 277 | 0 | 0 | 0 | 389 | 0 |
2021-28 | 824 | Description 4 | Department 4 | 41.7 | 8.34 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 41.7 |
2021-28 | 833 | Description 5 | Department 5 | 181.5 | 36.3 | 0 | 0 | 90 | 659 | 0 | 0 | 0 | 749 | 0 |
2021-29 | 101 | Description 6 | Department 1 | 41125.44 | 8225.09 | 10559 | 11191 | 5160 | 12222 | 433 | 4819 | 2807 | 47191 | 0 |
2021-29 | 102 | Description 7 | Department 2 | 12.6 | 2.52 | 0 | 12 | 0 | 0 | 12 | 0 | 0 | 24 | 0 |
2021-29 | 103 | Description 8 | Department 3 | 12663.75 | 2532.75 | 1653 | 2539 | 1682 | 2972 | 1183 | 1702 | 238 | 11969 | 694.75 |
2021-29 | 104 | Description 9 | Department 4 | 1714.25 | 342.85 | 2472 | 96 | 100 | 94 | 0 | 386 | 0 | 3148 | 0 |
2021-29 | 105 | Description 10 | Department 5 | 4016 | 803.2 | 2143 | 220 | 285 | 604 | 169 | 556 | 233 | 4210 | 0 |
2021-30 | 101 | Description 11 | Department 1 | 41125.44 | 8225.09 | 14176 | 11678 | 7645 | 10437 | 2718 | 0 | 0 | 46654 | 0 |
2021-30 | 102 | Description 12 | Department 2 | 12.6 | 2.52 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12.6 |
2021-30 | 103 | Description 13 | Department 3 | 12663.75 | 2532.75 | 477 | 2043 | 705 | 2968 | 0 | 0 | 0 | 6193 | 6470.75 |
2021-30 | 104 | Description 14 | Department 4 | 1714.25 | 342.85 | 468 | 169 | 165 | 152 | 189 | 0 | 0 | 1143 | 571.25 |
2021-30 | 105 | Description 15 | Department 5 | 4016 | 803.2 | 328 | 83 | 1365 | 787 | 766 | 0 | 0 | 3329 | 687 |
Thank you in advance for any help offered.
Solved! Go to Solution.
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
Proud to be a Super User!
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
Proud to be a Super User!
That is exactly what I needed. Thank you for your quick response.
you are welcome
Proud to be a Super User!