Re: Power BI / DAX

Anonymous · ‎12-26-2018

Hi ,

I am developing an Power BI report where I need to do an unpovit of data (common spearted data into rows). I dont think there is any function in DAX which can do this. How can this be achived ?

Ex : I have created an measure which returns value like : NA, Vitamin B Claim, Vitamin E Claim, Aging Claim

So i need to convert this into

NA

Vitamin B Claim

Vitamin E Claim

Aging Claim

Thanks in advance!

v-jiascu-msft · ‎12-27-2018

Hi @Anonymous,

Can you share some raw data, please? Maybe we can find a workaround.

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Greg_Deckler · ‎12-26-2018

There is no "Split" function in DAX:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/36217978-split-dax-function

I did create an unpivot in DAX:

https://community.powerbi.com/t5/Quick-Measures-Gallery/DAX-Unpivot/m-p/574832

Going to be difficult without a SPLIT command. You're going to need to try a different approach. Need source data really and seeing what your original calculations are. 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

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...