Resolved: Task Four Part 1 - My DAX Code for CountryOrder Column
CountryOrder = IF(dim_SalesTeritory[SalesTerritoryRegion] = "Australia",1,
IF(dim_SalesTeritory[SalesTerritoryRegion]="Canada",2,
IF(dim_SalesTeritory[SalesTerritoryRegion]="France",3,
IF(dim_SalesTeritory[SalesTerritoryRegion]="Germany",4,
If(dim_SalesTeritory[SalesTerritoryRegion] = "United Kingdom",5,
IF(dim_SalesTeritory[SalesTerritoryRegion]="NA",BLANK(),6))))))
IF(dim_SalesTeritory[SalesTerritoryRegion]="Canada",2,
IF(dim_SalesTeritory[SalesTerritoryRegion]="France",3,
IF(dim_SalesTeritory[SalesTerritoryRegion]="Germany",4,
If(dim_SalesTeritory[SalesTerritoryRegion] = "United Kingdom",5,
IF(dim_SalesTeritory[SalesTerritoryRegion]="NA",BLANK(),6))))))
3 answers ( 1 marked as helpful)
Hello, what is the question here?
I wanted to check if there can be a limitation for this to perform larger amount of data.
as far as I know there is no limitation in terms of nested if statements, however you may not want to overdo it, once you reach ten cases the code can be difficult to maintain and troubleshoot.