Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Last two complete weeks with text filter

Hi,   I have a issue I can't seem to figure out myself. I have a measure that counts number of rows from my table for the last two weeks from today. Then I use a filter to count only rows that cont...
Need Help
  • Ahmedx's avatar
    Ahmedx
    2 years ago

    try this

    Filtered Complete two weeks =

    VAR _ENG = CALCULATE([Last two complete weeks],
    FILTER(ALL(
    Table1),
    LEFT(Table1[Description], 3) = "Eng")
    )

    VAR _WA = CALCULATE([Last two complete weeks],
    FILTER(ALL(
    Table1),
    LEFT(Table1[Description], 3) = "Wal")
    )
    Return
    _ENG + _WA

Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
2 years ago

try this

Filtered Complete two weeks =

VAR _ENG = CALCULATE([Last two complete weeks],
FILTER(ALL(
Table1),
LEFT(Table1[Description], 3) = "Eng")
)

VAR _WA = CALCULATE([Last two complete weeks],
FILTER(ALL(
Table1),
LEFT(Table1[Description], 3) = "Wal")
)
Return
_ENG + _WA