Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
hihi
Frequent Visitor

Split value of a id to other id with percent of other id with souce.

i have a table like: 

hihi_0-1703673585780.png

can everyone help me with dax to calculate this expression?

Thanks and best regards.

 

3 REPLIES 3
Fowmy
Super User
Super User

@hihi 

not enough details to understand the context and the requirements. Please show the column and row details in the spreadsheet to understand the formula


Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

hihi
Frequent Visitor

I'm sorry, that's my full table.

hihi_0-1703685657537.png

 

HI @hihi,

AFAIK, current power bi data model does not include row and column index and the Dax expressions not able to apply recursion calculations. You may need to do this type of calculation out of power bi, then getting data from calculated results.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.