Calculated or Virtual table based on 3 tables

[Anonymous]

Hi,

i have 3 Tables

Now i need to create a new table based on that

it should have as 1st column the date and all other column headers should be the value of location name. The values should be the count of case ids.

 The result should be look like that:

How can this been archived?

Thanks & Regards

[amitchandak · Accepted solution]

@Anonymous , Create a matrix visual and then add date to row and location to column count of case id to values

Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.

[Anonymous]

hi,

i did not want to have a visual. I need to create a table to calculate further calculations.

p.s. i did already try to use a vaisual but the totals where not calculated right.

Regards