Calculate daily turnover

[Christophe_]

Hello together
I have a date table (one row for each day) with a column "working day", which defines if the date is a working day (1), or not (0).
In a second table I have the daily sales per item code.
now i need a measure that multiplies the column working day with the daily turnover; with this i want to calculate the planned turnover per day.
But currently I have the problem that I don't know how to link the two table in a meaningful way (in the planning file I have no date, in the date file no category code).
Is it possibly useful to calculate the sales in the date table in Excel?
Or are there better possibilities?
Thanks for any help
Christophe

[Christophe_]

Thank you @Greg_Deckler for your answer

I have two tables (see below), these are linked via the "Year" column.

Furthermore I have following measure:

Output =

SUMX(

    'Daten',

    Daten[Working Day] * MAX('Output daily'[Plan actual])

)

The measure should calculate the production output for each day per item. The matrix shows that the total per Item and month is calculated correctly. But the total per month (currently the total of article A ist output, i.e. the maximum value) and the grand total is not correct (6'006'000 is the total of article A, but not the total of all articles: this would be 10'094'700).
I assume that the MAX function in the measure is the problem?

How can I convert the measure so that the output per day is correctly summed to the month and year?

Matrix in PBI:

Table "Output daily":

Item Code	Plan actual	Year
A	26000	2023
B	13000	2023
C	4700	2023

Table "Daten":

Data	Year	Working Day	YYMM
01.01.2023	2023	0	2301
02.01.2023	2023	0	2301
03.01.2023	2023	1	2301
04.01.2023	2023	1	2301
05.01.2023	2023	1	2301
06.01.2023	2023	1	2301

[Christophe_ · Accepted solution]

I think i have found a solution by replacing MAX with SUM

Output 1 =

SUMX(

    'Daten',

    Daten[Working Day] * SUM('Output daily'[Plan actual])

)

[Greg_Deckler]

That makes sense to me.

[Greg_Deckler]

@Christophe_ Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.