Use Pivot result

[AndreaITAMIL]

Hi

i have a simple pivot, how can i take the result of my pivot to create a new measure?

Thanks

[Greg_Deckler]

Please vote for my Idea for a DAX function called MAGIC. Otherwise, Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[AndreaITAMIL]

i try to explain

From a table i create the pivot image over

How can i use the column result into a formula?

[v-deddai1-msft]

Hi @AndreaITAMIL ,

Sorry for can't understand what you really want. Would you please refer to the link below  to  pivot and unpivot column in query editor: https://databear.com/power-bi-pivot-and-unpivot-columns/

Best Regards,

Dedmon Dai