Chalenge Power QUERY OR DAX

Copper Contributor

Hello my friends


please i have problem, how I can move the excel formula in yellow color area to power query or DAX? 

2 Replies
best response confirmed by Jalal_1988 (Copper Contributor)
I presume the shared data is pivot and the source of the pivot can be imported as a source to the Power query.

Data --> Get Data --> from based on your source file

thanyou for your ideia but l don't want this way, I want directly achieve it @Vinod2406