topic Re: Split value of a id to other id with percent of other id with souce. in DAX Commands and Tips

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

hihi — Wed, 27 Dec 2023 10:41:03 GMT

i have a table like:

can everyone help me with dax to calculate this expression?

Thanks and best regards.

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

Fowmy — Wed, 27 Dec 2023 11:15:43 GMT

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

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

hihi — Wed, 27 Dec 2023 14:01:11 GMT

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

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

Anonymous — Fri, 29 Dec 2023 05:45:12 GMT

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