Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
116 | |
82 | |
47 | |
42 | |
28 |
User | Count |
---|---|
186 | |
80 | |
72 | |
48 | |
45 |