IT Consultant

gvamsimba

<div>
Perfect Tom, the below DAX Switch True worked like a charm.<br><br>vtest = SWITCH( TRUE(),[Recordtypename__c] = "Places Development OS","Open Market",<br>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;[Recordtypename__c] = "Places Development SO","Shared Ownership",<br>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;[Recordtypename__c] = "Places Development SE","Shared Equity",<br>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;[Recordtypename__c])<br><br><br>
</div>


Perfect Tom, the below DAX Switch True worked like a charm.

vtest = SWITCH( TRUE(),[Recordtypename__c] = "Places Development OS","Open Market",
               [Recordtypename__c] = "Places Development SO","Shared Ownership",
               [Recordtypename__c] = "Places Development SE","Shared Equity",
               [Recordtypename__c])




<div>
<div class="content wysiwyg-content fr-view">
hi , I m developing a powerbi matrix report and my row data is a look up column and I have to group &nbsp;some values into one value ..<br><br>example - IF the column has values AB or BC or <br>CZ then display as New , IF values are FE of ZS then Old Else&nbsp;<br><br>In SQL I can easily write CASE statement . My data source is sales force . can anyone plz give me the DAX query to achieve my requirement so tat I can then use tat column in my matrix rows ?<br>If I then pull &nbsp;the customer counts in the data section will it group correctly ?<br><br>many thanks&nbsp;
</div>
</div>



hi , I m developing a powerbi matrix report and my row data is a look up column and I have to group  some values into one value ..
example - IF the column has values AB or BC or
CZ then display as New , IF values are FE of ZS then Old Else 
In SQL I can easily write CASE statement . My data source is sales force . can anyone plz give me the DAX query to achieve my requirement so tat I can then use tat column in my matrix rows ?
If I then pull  the customer counts in the data section will it group correctly ?
many thanks 

CASE statement equivalent to in DAC

Power BI is a business analytics tool from Microsoft used for data visualization. It integrates seamlessly with other tools, like Microsoft Excel, and is easily embedded in websites and apps. Power BI offers live dashboards and visual reports to help “bring your data to life.” There are many opportunities for customization, as well as built-in options for your visualizations and analytics. With the Power BI mobile app, you can receive push notifications about important data changes, allowing you to react and plan right away.