Power BI / DAX

[Anonymous]

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]

Hi @Anonymous,

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

Best Regards,
Dale

[Greg_Deckler]

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