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