Forum Discussion

Soulbroda's avatar
Soulbroda
Frequent Visitor
4 years ago

Split Quarter into Month Columns

I am currently working on a Power BI report that requires having the months of a quarter represented as columns. Curious to know if this is even possible. I tried using transpose but that didn't work.

 

I have attached a snapshot of the report. The table at the top of the picture shows my current Power BI report and the table below shows the Excel file with January, February, and March having their individual columns.

 

 

Need Help
Tips and Tricks
Tutorial Requests

2 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    4 years ago

    Hi,

    How is your source data table arranged?  Share data here in a format that can be pasted in an MS Excel file.   

  • Soulbroda's avatar
    Soulbroda
    Frequent Visitor
    4 years ago

    I am sourcing data from different tables using a SQL query to achieve this. Kindly find below the output of the query having just the date columns visible.

     

     

    -