The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello,
I would appreciate help with 2 issues below, I am new to PowerBI.
1. I want to create a new column called category which would compare several columns in a fact table to categorize each Purchase order. I tried a switch code but I got the below error
2. I want to compare the resultant Category "No GR, NO IR" to the aging of the delivery date to know if the PO is overdue. The criteria is if "No GR, No IR" > 1 day = PO Overdue.
Thank you for your help.
missing ")" to end the switch function.
Thank you so much for the prompt response! I am starting to understand the importance of commas, columns, quotation marks etc.
User | Count |
---|---|
28 | |
12 | |
8 | |
7 | |
5 |
User | Count |
---|---|
36 | |
14 | |
12 | |
7 | |
7 |