Forum Discussion

lt79_Pax's avatar
lt79_Pax
Helper II
5 years ago
Solved

Data Lineage SelectOnlyC2 error

Dear Power BI Representative, I am reviewing Chapter 14 of The Definitive Guide to DAX and in the 'Understanding data lineage' section I was running the following code in DAX Studio as directed.  Ho...
  • AlB's avatar
    AlB
    5 years ago

    Hi lt79_Pax 

    you probably need

    VAR AddC2 =
        ADDCOLUMNS ( NonBlueColors, "C2", 'Product'[Color] )

     

    instead of

     

    VAR AddC2 =
        ADDCOLUMNS ( NonBlueColors, "[C2]", 'Product'[Color] )

     

    Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

    Cheers 

     

AlB's avatar
AlB
Community Champion
5 years ago

Hi lt79_Pax 

you probably need

VAR AddC2 =
    ADDCOLUMNS ( NonBlueColors, "C2", 'Product'[Color] )

 

instead of

 

VAR AddC2 =
    ADDCOLUMNS ( NonBlueColors, "[C2]", 'Product'[Color] )

 

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers