Filter on multiple companies to find value at a certain date

[PowerBI_Noob123]

Hi, I am new to Power BI and would like to filter on companies to find a date value, but cant seem to structure my data correctly. This is a short example of my data: 

F.ex. I would like to filter on both company and date to extract a value (yellow cell f.ex). How would I need to structure my data/relationships to manage this? Thank you!

[johnt75]

I would change the structure so that instead of having each company in a column the table has 3 columns: Date, Company and Value. Then create a proper date table with a one-to-many relationship to both your fact tables and create a dimension table which has all of the companies and which has a one-to-many relationship to both your fact tables. Then you can use columns from your new date and company tables in visuals or filters to show the value for a given company and date combination.