October 28 & 29: Experts share their secrets on how to pass the Fabric Analytics Engineer certification exam—live. Learn more
Hi,
If I have an invoice status column that contains data such as invoiced, not invoiced, on hold, paused: Is it possible to create one group with invoiced and not invoiced and a second group with invoiced, on hold and paused? Possible to have invoiced in both groups?
BR
Nazeem
Solved! Go to Solution.
Hi @Nazeem81,
In 'Input' table, add two calculated columns:
Group1 = IF(Input[Invoice status]="Invoiced"||Input[Invoice status]="Not invoiced","Group1") Group2 = IF(Input[Invoice status]="Invoiced"||Input[Invoice status]="On hold"||Input[Invoice status]="Paused","Group2")
Then, new a calculated table as below:
Output_1 = UNION ( SELECTCOLUMNS ( FILTER ( Input, Input[Group1] <> BLANK () ), "Date", Input[Date], "Invoice Number", Input[Invoice number], "Invoice Status", Input[Invoice status], "Group", Input[Group1] ), SELECTCOLUMNS ( FILTER ( Input, Input[Group2] <> BLANK () ), "Date", Input[Date], "Invoice Number", Input[Invoice number], "Invoice Status", Input[Invoice status], "Group", Input[Group2] ) )
Use a Matrix to display data from 'Output_1'.
Best regards,
Yuliana Gu
Hi @Nazeem81,
In 'Input' table, add two calculated columns:
Group1 = IF(Input[Invoice status]="Invoiced"||Input[Invoice status]="Not invoiced","Group1") Group2 = IF(Input[Invoice status]="Invoiced"||Input[Invoice status]="On hold"||Input[Invoice status]="Paused","Group2")
Then, new a calculated table as below:
Output_1 = UNION ( SELECTCOLUMNS ( FILTER ( Input, Input[Group1] <> BLANK () ), "Date", Input[Date], "Invoice Number", Input[Invoice number], "Invoice Status", Input[Invoice status], "Group", Input[Group1] ), SELECTCOLUMNS ( FILTER ( Input, Input[Group2] <> BLANK () ), "Date", Input[Date], "Invoice Number", Input[Invoice number], "Invoice Status", Input[Invoice status], "Group", Input[Group2] ) )
Use a Matrix to display data from 'Output_1'.
Best regards,
Yuliana Gu
Potentially, yes. But tough to say with the information provided:
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
Hi,
Thanks for the reply. What more information do you need?
BR
Ammar
Sample/example input data and then example/sample of output is always helpful.
User | Count |
---|---|
104 | |
97 | |
96 | |
85 | |
49 |
User | Count |
---|---|
162 | |
142 | |
132 | |
102 | |
63 |