The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the July 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
108 | |
68 | |
46 | |
43 |
User | Count |
---|---|
188 | |
87 | |
77 | |
74 | |
60 |