Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Calculated Table from based on values from another table

Hello,   I have a table with Staff Name and Status Number as follows:   Date Staff Name Status Number 01/11/2022 A 1 01/11/2022 A 2 01/11/2022 A 3 01/11/2022 A 4 01/11...
General Comment
Need Help
Show and Tell
  • mariussve1's avatar
    mariussve1
    3 years ago

    Then you can try something like this:

    Calculated table =
    VAR __Filter =
        CALCULATETABLE( VALUES( Staff[StaffName] ), Staff[StaffNumber] = 2 )
    VAR __Result =
        FILTER (
            SUMMARIZECOLUMNS ( Staff[Date], Staff[StaffName] ),
            NOT ( Staff[StaffName] ) IN __Filter
        )
    RETURN __Result
     
    Br
    Marius
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hello Marius. That would be great!

Can you please send it to [email protected]?

mariussve1's avatar
mariussve1
Solution Sage
3 years ago

I have now sendt you an email with the example .pbix file that works as expected 🙂
Please let me know how it goes.

Br

Marius