Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Reference the whole column data from another query to one query

Dear all,   Can PBI PQ reference the whole column data from another query?  If not, can other methods be used, such as DAX?   1, I have two queries arranged into PQ, one with data, another just w...
  • Vijay_A_Verma's avatar
    4 years ago

    None of the pics got posted, somehow.

    PQ can refer to entire column data. Preferred method is to refer to as a list.

    Let's say query is named Query2 and column is named Data. Then you can refer to whole column by 

    =Query2[Data]