Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Innerjoin Challenge

  Hello Power friends, some help, please.   I have two tables as below:   Planned Sales id_store, id_department, date, sales on month (planned)   01, 222,01/01/2018, 100 01, 222,01/02/2018, ...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi Anonymous,

     

    Try this formula, please. Please also download the demo from the attachment.

    Table =
SELECTCOLUMNS (
    ADDCOLUMNS (
        'plan',
        "New Col",
        VAR salesValue =
            LOOKUPVALUE (
                sales[Sales],
                sales[id_store], [id_store],
                sales[id_department], [id_department],
                sales[date], [date]
            )
        RETURN
            IF ( ISBLANK ( salesValue ), [Planed], salesValue )
    ),
    "id_store", [id_store],
    "id_department", [id_department],
    "date", [date],
    "Sales Planed or Real", [New Col]
)

    Innerjoin-Challenge

     

    Best Regards,
    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi Anonymous,

 

Try this formula, please. Please also download the demo from the attachment.

Table =
SELECTCOLUMNS (
    ADDCOLUMNS (
        'plan',
        "New Col",
        VAR salesValue =
            LOOKUPVALUE (
                sales[Sales],
                sales[id_store], [id_store],
                sales[id_department], [id_department],
                sales[date], [date]
            )
        RETURN
            IF ( ISBLANK ( salesValue ), [Planed], salesValue )
    ),
    "id_store", [id_store],
    "id_department", [id_department],
    "date", [date],
    "Sales Planed or Real", [New Col]
)

Innerjoin-Challenge

 

Best Regards,
Dale

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Great solution v-jiascu-msft. Thanks a lot.