Forum Discussion
Merge Office Counts rows into single count
Hello - I am trying to combine multiple version counts of office into a single row. Basically i want the Piechart object to only show a count of Office 365 installations but the qu...
Anonymous,
Please use DAX below.New name = IF(LEFT(Query2[Software Name],20)="Microsoft Office 365","Microsoft Office 365",IF(LEFT(Query2[Software Name],39)="Microsoft Office Professional Plus 2013","Microsoft Office 2013",Query2[Software Name]))
Regards,
Lydia
Anonymous,
You can create a new column in your table below, then involve the column in your visual or calculation.
New name = IF(LEFT(Table1[Display name],20)="Microsoft Office 365","Microsoft Office 365 installation",Table1[Display name])
Regards,
Lydia
Thank you!! That worked -
Is there a way to continue the string to handle multiple variables?
ex.
New name = IF(LEFT(Query2[Software Name],20)="Microsoft Office 365","Microsoft Office 365",Query2[Software Name])
and
(LEFT(Query2[Software Name],39)="Microsoft Office Professional Plus 2013","Microsoft Office 2013",Query2[Software Name])
Anonymous,
Please use DAX below.New name = IF(LEFT(Query2[Software Name],20)="Microsoft Office 365","Microsoft Office 365",IF(LEFT(Query2[Software Name],39)="Microsoft Office Professional Plus 2013","Microsoft Office 2013",Query2[Software Name]))
Regards,
Lydia