Forum Discussion
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 active contracts or not. My raw data is presented like this:
I need to make the above table look like this:
Once I am able to display the above, I can manipulate it to provide the appropriate counts, etc.
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
5 Replies
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