Forum Discussion
DAX convert
SELECT [Group Count By User].[User Id], [Group Count By User]. Count002, IIf([Group Count By User] [Count002]>=1,"Good","Bad") AS Status, [Group Count By User].[Group Count], IIf([Group Count By User]![Group Count]>=3,"Good","Bad") AS Status_old
FROM [Group Count By User];
Converting the above to DAX
Hi Anonymous ,
First, make sure the SQL table "Group Count By User" has been loaded into Power BI. Then create calculated columns or measures as below to get Status and Status_old by function IF. and drag them onto the table visual.You can check all the details from the following screen shot.
1. Create calculated columns
Status = IF('Group Count By User'[Count002]>=1,"Good","Bad")Status_old = IF('Group Count By User'[Group Count]>=3,"Good","Bad")2. Create measures
MStatus = IF(MAX('Group Count By User'[Count002])>=1,"Good","Bad") MStatus_old = IF(MAX('Group Count By User'[Group Count])>=3,"Good","Bad")Best Regards
Rena
3 Replies
Anonymous - Yeah, generally easier to post the data and expected output, looks like a SELECTCOLUMNS and an nested IF statement so I would use a SWITCH probably.
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, 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
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.Anonymous , You just need two columns
Status =If('Group Count By User' [Count002]>=1,"Good","Bad")
Status_old= If('Group Count By User'[Group Count]>=3,"Good","Bad")Other you can drag on a visual.
Or you can use select columns -https://docs.microsoft.com/en-us/dax/selectcolumns-function-dax
Hi Anonymous ,
First, make sure the SQL table "Group Count By User" has been loaded into Power BI. Then create calculated columns or measures as below to get Status and Status_old by function IF. and drag them onto the table visual.You can check all the details from the following screen shot.
1. Create calculated columns
Status = IF('Group Count By User'[Count002]>=1,"Good","Bad")Status_old = IF('Group Count By User'[Group Count]>=3,"Good","Bad")2. Create measures
MStatus = IF(MAX('Group Count By User'[Count002])>=1,"Good","Bad") MStatus_old = IF(MAX('Group Count By User'[Group Count])>=3,"Good","Bad")Best Regards
Rena
