Create table only on Thursdays of each week

[Syndicate_Admin]

Hello community, cordial greeting.

Can you help me with the following case please, I have a consolidated table of the day to day (attached image) but I just want to get in another new table the same records (rows) but only with the Thursdays of each week.

Thank you very much in advance.

Walter

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure if I understood your question correctly, but please check the below picutre and the attached pbix file.

I assume your calendar table does not have weeknumber column.

New Table =

FILTER ( 'Calendar', WEEKDAY ( 'Calendar'[Date] ) = 5 )