Forum Discussion

Resolver II

3 years ago

Adding a Calculated Table to Model

Hi. I am trying to summarize metrics from six tables by week range. All six of them have the same category of metrics but for different business units. Each row in each of the tables has a date colum...

Need Help

FreemanZ

Super User

3 years ago

hi yasbos

try to append six tables in POWER QUERY first and related the calendar table with the appended table only.

https://support.microsoft.com/en-us/office/append-queries-power-query-e42ca582-4f62-4a43-b37f-99e2b2a4813a#:~:text=1%20In%20the%20POWER%20QUERY%20or%20Query%20Editor,displays%20a%20new%20query%20in%20the%20query%20editor.

Forum Discussion

Adding a Calculated Table to Model

Related content

Adding calculated column to date table

Adding filters to a calculated column

Direct Lake Model - Calculated Column/Tables

How to search specific word in table filter Calculations

Table Visual not Matching Calculated Visual