User Profile
gowtham1991
Frequent Visitor
Joined 3 years ago
User Widgets
Contributions
Transformming table columns
Hello Experts, I have an input table like the below Itemid projectid name ML0 ML1 ML2 ML3 ML4 ML5 ML6 ML7 123 name1 release2,release1,release 3 release4,release5,release6,release7 release8 and the expected output table to be displayed in power bi is Itemid projectid name release1 release2 release3 release4 release5 release6 release7 release8 123 name1 ML0 ML0 ML0 ML2 ML2 ML2 ML2 ML5 I would seek your support or suggestion in how to get this done. Thanks GowthamSolved1.3KViews0likes8CommentsConverting rows to column
hello, I have da data table in the below format Feature List ML1 ML2 ML3 ML4 Feature 1 Release 1 Reease 4 Release 5 Feature 2 Release 2 Reease 5 Release 6 Feature 3 Release 3 Reease 6 Release 7 Feature 4 Release 4 Release 6 Reease 7 Release 8 Feature 5 Release 5 Release 7 Reease 8 Release 9 Feature 6 Release 6 Release 8 Reease 9 Release 10 Feature 7 Release 7 Release 9 Reease 10 Release 11 Feature 8 Release 8 Release 10 Reease 11 Release 12 and the expected outcome should be as beow Feature List Release 1 Release 2 Release 3 Release 4 Release 5 Feature 1 Ml1 ML3 ML4 Feature 2 ML2 Feature 3 ML1 Feature 4 ML1 Feature 5 Feature 6 Feature 7 Feature 8 I am bit struggling to convert the table in specified format, any suggestions and ideas would be helpful Thanks GowthamSolved1.2KViews0likes3CommentsRe: DistinctCount not showing the correct numbers
Bibiano_Geraldo Thanks you for your replay, Unfortunately this does not solve the issue. Note:, Not all the values are wrong, I have only few rows showing a incorrect date. In the acatual fileI have atmost 300K rows and nealy 100+ rows showing incrrect values a1.2KViews2likes1Comment
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.