Add by filtering by the date of a column

[XaviOV]

Hello

I have two tables one with the date values (unique) and another table with date values (repeated) and with different values that I want to sum based on the date and the column of "line" excluding line 4.

Example:

Best regards!

[v-deddai1-msft · Accepted solution]

Hi @XaviOV ,

Just create calculated column in table1:

column =
CALCULATE (
    SUM ( 'Table2'[plts] ),
    FILTER (
        'Table2',
        'Table2'[Week] = EARLIER ( 'Table1'[Week] )
            && 'Table2'[line] <> 4
    )
)

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[amitchandak]

@XaviOV , Not very clear,

you can join both of the tables, if dates are unique in table 2 .you can join them together and analyze. Or join to common date table and analyze 

In such case

use measure = calculate(sum(Table1[pits]), filter(Table1,Table1[line]<>4))

if you want table2 from table1

table 2 = summarize( Table, Table[Week], "Suma plts",calculate(sum(Table1[pits]), filter(Table1,Table1[line]<>4)))

if you want new column in table2 from table 1

New column in table 2 = sumx(filter(Table1,Table1[line]<>4 && Table1[week] = Table2[week]),sum(Table1[pits]))

[Fowmy]

@XaviOV 

Go to Modeling Table > New Table and Paste the following code, it will create anew table with the result as you expect.

Table5 Summarized = 

SUMMARIZE(
    FILTER(Table5,Table5[line]<>4),
    Table5[Week],
    "Total", SUM(Table5[plts])
)

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn