Multiple Filter in same table

[AllanBerces]

Hi Good day, can anyone help me on my measure. I want to sum the Daily Earned from Week 1 to Prevuios Week, but i have to filter my table as below.

 - Condition column is not equal to Bad
 - Trade Column is equal to AAA, CCC, BBB, AWE
- Week No. from 01 to Previous Week

- Year is equal to 2024

Thank you

[Anonymous · Accepted solution]

Hi @AllanBerces 

Please try this:

You can create a calculated table:

FILTER (
    'YourTable',
    [Condition] <> "Bad"
        && [Trade]
            IN { "AAA", "CCC", "BBB", "AWE" }
                && [Year] = 2024
                && [Week No.] < WEEKNUM ( TODAY () )
)

Best Regards

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

[AllanBerces]

Hi @Anonymous thank you for the reply and its work perfectly.

Thank you

[Uzi2019]

Hi @AllanBerces 

can you share the date or paste the data so that we can work on your data directly???
just copy and paste from excel file to here..

[AllanBerces]

Hi @Uzi2019  error when i paste the excel.

[Uzi2019]

Hi @AllanBerces 

dont paste the excel file.. copy the excel data and directly.. like this

Apr	May	Jun	Jul	Aug	Sep
12573134	10281632	18085646	59995353	29714330	22396688
125747	0	0	38566362	5898525	0
20400	200000	0	0	0	0
12426988	10081632	18085646	21428991	23815806	22396688
736500	100471	7631931	6399348	8920562	6532284
11690488	9981161	10453715	15029643	14895244	15864404