Forum Discussion
Power BI / DAX
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!
2 Replies
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
Hi Anonymous,
Can you share some raw data, please? Maybe we can find a workaround.
Best Regards,
Dale
