Page 1 of 1
DAX function in Power BI in 1) Create a new column IncomeStatus in DimCustomer ✓With the conditions: CE1-PowerBI-DAX-You
Posted: Tue Jul 12, 2022 8:16 am
by answerhappygod
- Dax Function In Power Bi In 1 Create A New Column Incomestatus In Dimcustomer With The Conditions Ce1 Powerbi Dax You 1 (60.48 KiB) Viewed 17 times
DAX function in Power BI in 1) Create a new column IncomeStatus in DimCustomer ✓With the conditions: CE1-PowerBI-DAX-YourLastName-YourFirstName.pbix • If CustomerType="Person" and YearlyIncome <39560, IncomeStatus="Lower-class" • If CustomerType="Person" IncomeStatus="Middle-class" and YearlyIncome >= 39560 and YearlyIncome < 118080, • If CustomerType="Person" • Else, IncomeStatus="N/A" (the CustomerType="
Company") and YearlyIncome >= 118080, IncomeStatus="Upper-class"