Pivotby TEXT values

[kwennerberg]

Can one use TEXT values (columns) in the new Pivotby function? (Of course, I don't have access to it yet.) To be clear, in "regular" Pivot Tables one is limited to numeric values only. I believe Power BI provides a workaround allowing text , but that is now what I am seeking.

 

[RoryA]

Yes you can. You can use something like ARRAYTOTEXT, or you can use LAMBDAs for the functions so you can use things like TEXTJOIN for example.