Extract header with current month

[Rohini]

Hi PBI Comm,

My data has the following headers (field names), with the insights fields having text data:

Is there a way I can extract that insights column pertaining to current month retaining the other columns (Column1, Column2 ...), without transposing or pivoting the entire table?

[v-yuaj-msft]

Hi @Rohini ,

Maybe I'm not getting what actually you are trying to do. Could you please share the expected result to have a clear understanding of your question? I can do some tests for you.

Is the following result what you want?

Best Regards,

Yuna