Forum Discussion

alderete-tomas's avatar
alderete-tomas
Frequent Visitor
3 years ago

Combine tables within different date between them

The model has several queries where there are three that I need to match. First, a table of people containing ID+(yearmonth) as a unique ID but it is not connected to calendar as the table people has...
johnt75's avatar
johnt75
Icon for Super User rankSuper User
3 years ago

Its not a good idea to add columns using SUMMARIZE, see this article from SQLBI.

Instead, use ADDCOLUMNS, e.g.

BI_HC =
SUMX (
    ADDCOLUMNS (
        SUMMARIZE ( Personas, Personas[Key] ),
        "BIHC", [Remuneración (Sin Horas Extras) Mes Ant] * [Operativos]
    ),
    [BIHC]
)