Resolved: Task Four Part 1 - My DAX Code for CountryOrder Column

Question

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))))))

Answer 1

Dimitar Shutev

Instructor

Posted on:

06 Aug 2025

0

Hello, what is the question here?

Answer 2

I wanted to check if there can be a limitation for this to perform larger amount of data.

Answer 3

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.

Resolved: Task Four Part 1 - My DAX Code for CountryOrder Column

Submit an answer

related questions