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