Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

TREATAS with variables as inputs

My struggle to learn and comprehend the intricacies of TREATAS continues (not that I'm complaining, learning is fun). Thanks for solving my previous problem, which was mainly self-inflicted by not...
DallasBaba's avatar
DallasBaba
Icon for Skilled Sharer rankSkilled Sharer
2 years ago

Anonymous Thanks for letting me know error message using TREATAS Function. Let try using  the SUMMARIZE function

VAR A_TreatAs =
    TREATAS (
        SUMMARIZE(P_B, P_B[ProductKey], P_B[Name], P_B[Brand]),
        SUMMARIZE(P_A, P_A[ProductKey], P_A[Name], P_A[Brand])
    )

VAR Result =
    NATURALLEFTOUTERJOIN ( P_A, A_TreatAs )

RETURN Result

 The SUMMARIZE function will create temporary tables with the necessary columns, preserving their original names. This should resolve the issue with the TREATAS function. The TREATAS function expects fully qualified column references, and by using SUMMARIZE, you ensure that the column references are in the correct format.


Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

Let me know if this works
Thanks

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    DallasBaba Still the same issue.

    • DallasBaba's avatar
      DallasBaba
      Icon for Skilled Sharer rankSkilled Sharer
      2 years ago

      Anonymous can you share the pbix sample data, or replace the code with the following and check if it works for your specific case.

      VAR A_TreatAs =
    TREATAS (
        SUMMARIZE(P_B, P_B[ProductKey], P_B[Name], P_B[Brand]),
        ADDCOLUMNS(
            SUMMARIZE(P_A, P_A[ProductKey], P_A[Name], P_A[Brand]),
            "DummyColumn", 1
        )
    )

VAR Result =
    NATURALLEFTOUTERJOIN ( P_A, A_TreatAs )

RETURN Result

      Note: A "DummyColumn" will be added to the SUMMARIZE result of P_A to make it a fully qualified table, which can then be used in the TREATAS function. This should bypass the "Function TREATAS expects a fully qualified column reference" error.