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
Thank you in advance for any help offered.
Go to Solution.
maybe try to create a column in date and use that column to filter data
VAR _ProdWeekYear=maxx(FILTER('Table (2)','Table (2)'[Date]=today()),'Table (2)'[ProdWeekYear])
pls see the attachment below
Proud to be a Super User!
View solution in original post
That is exactly what I needed. Thank you for your quick response.
you are welcome
Check out the News & Announcements to learn more.
Click here to read more about the October 2021 Release!
Check out the new Power Platform Community Connections gallery!
Mark your calendars and join us for our next Power BI Dev Camp!