Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    6 years ago

    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

     

     

     

     

     

     

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

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.