Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Data Manipulation/Calculated Column Creation Help

Hello, I am perplexed by a problem on how to manipulate my data.  Essentially, I need to create a new column that determines if a customer account is active or inactive based on whether they have any...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Anonymous

     

    Create 3 measures for this.

    Status = IF([Active Contracts]>0, "Active","Inactive")

Active Contracts =  CALCULATE(COUNT('Status Column'[Contract Number]), FILTER('Status Column','Status Column'[Status]="Active"))

InActive Contracts = CALCULATE(COUNT('Status Column'[Contract Number]), FILTER('Status Column','Status Column'[Status]="Inactive"))

     

     

    Hope this is clear.

     

    Thanks
    Raj

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi

  Can you please post the data in text format so that it can be copied?

 

Thanks
Raj

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

     

    Here you go:

    Customer NumberContract NumberContract Status
    1231000TRUE
    1232000TRUE
    4563000FALSE
    4564000TRUE
    4565000

    TRUE

    7896000

    FALSE

    7897000

    FALSE

    7898000

    FALSE

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi Anonymous

       

      Create 3 measures for this.

      Status = IF([Active Contracts]>0, "Active","Inactive")

Active Contracts =  CALCULATE(COUNT('Status Column'[Contract Number]), FILTER('Status Column','Status Column'[Status]="Active"))

InActive Contracts = CALCULATE(COUNT('Status Column'[Contract Number]), FILTER('Status Column','Status Column'[Status]="Inactive"))

       

       

      Hope this is clear.

       

      Thanks
      Raj

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        should the 'Status Column' in your measures be the table name? ex: Active Contracts = CALCULATE(COUNT('Sheet1'[Contract Number]), FILTER('Sheet1','Sheet1'[Status]="Active")) 

         

        When I use the table/column name conventions, I'm prompted with this dialogue box: