Forum Discussion

AngusTan's avatar
AngusTan
Frequent Visitor
6 years ago

Plotting Calculated Column Months into a stack column chart

Hello,   I'm a new PowerBI user who just started learning this program.   I'm working on a resource loading visualization that pulls data from a database and applies a function to calculate the l...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi AngusTan ,

 

Please refer to the formula below to create a calculated table.

BTW, it would be better to share some sample data to us if you don't have any Confidential Information. In that case we might be able to help you find another way instead of creating 12 calculated column.

Table 2 = 
UNION (
    SELECTCOLUMNS (
        'Table',
        "item", 'Table'[Item],
        "person", 'Table'[Person],
        "amount", 'Table'[Jan],
        "month", "Jan"
    ),
    SELECTCOLUMNS (
        'Table',
        "item", 'Table'[Item],
        "person", 'Table'[Person],
        "amount", 'Table'[Feb],
        "month", "Feb"
    )
)

 Result would be shown as below.

 

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.