Forum Discussion

Rohini's avatar
Rohini
Helper I
5 years ago

Extract header with current month

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?

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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