topic Power BI / DAX in Developer

Power BI / DAX

Anonymous — Wed, 26 Dec 2018 11:30:26 GMT

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

Vitamin B Claim

Vitamin E Claim

Aging Claim

Thanks in advance!

Re: Power BI / DAX

Greg_Deckler — Wed, 26 Dec 2018 16:07:36 GMT

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

Re: Power BI / DAX

v-jiascu-msft — Thu, 27 Dec 2018 08:27:56 GMT

Hi @Anonymous,

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

Best Regards,
Dale