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 achive...
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