HiI’m new do DAX and PowerBI and trying to get the hang of it, but I’m stuck. I will try to the best of my abilities describe what I need to do. I would like to create a new column in my datatable called “Category”, in which a text is added depending on conditions in the form of a “Code”. If no condition is found in my rules table, fetch the “DefaultCategory” from my suppliers table.I have my Datatable as example below:SupplierIDSupplierNameAmountCodeCategory123Name 1100055 123Name 150033 555Name 275055 555Name 275044 I also have a table for my suppliers:SupplierIDSupplierNameDefaultCategory123Name 1Categoryname 1555Name 2Categoryname 1 I also have a table for rules to override the DefaultCategory:SupplierIDCodeNewCategory12333Categoryname 255544Categoryname 3 I would like the result to return like this:IDSupplierNameAmountCodeCategory123Name 1100055Categoryname 1123Name 150033Categoryname 2555Name 275055Categoryname 1555Name 275044Categoryname 3 If anyone could help me I would really appreciate it.

Hi Myshydde , If I understand you’re question. You’re looking for something like this?

Frequent Visitor

3 years ago

Solved

Help witch fetching values from another table depending on conditions

I’m new do DAX and PowerBI and trying to get the hang of it, but I’m stuck. I will try to the best of my abilities describe what I need to do. I would like to create a new column in my datatable called “Category”, in which a text is added depending on conditions in the form of a “Code”. If no condition is found in my rules table, fetch the “DefaultCategory” from my suppliers table.

I have my Datatable as example below:

SupplierID	SupplierName	Amount	Code	Category
123	Name 1	1000	55
123	Name 1	500	33
555	Name 2	750	55
555	Name 2	750	44

I also have a table for my suppliers:

SupplierID	SupplierName	DefaultCategory
123	Name 1	Categoryname 1
555	Name 2	Categoryname 1

I also have a table for rules to override the DefaultCategory:

SupplierID	Code	NewCategory
123	33	Categoryname 2
555	44	Categoryname 3

I would like the result to return like this:

ID	SupplierName	Amount	Code	Category
123	Name 1	1000	55	Categoryname 1
123	Name 1	500	33	Categoryname 2
555	Name 2	750	55	Categoryname 1
555	Name 2	750	44	Categoryname 3

If anyone could help me I would really appreciate it.

Need Help

SomeDataDude
3 years ago
Hi Myshydde ,

If I understand you’re question. You’re looking for something like this?

SomeDataDude

3 years ago

I add an extra search value in the LOOKUPVALE() to match the first criteria. In the first line were checking the rule code and supplier, if they match with Data[Code]. We return the NewCategory. Otherwise the DefaultCategory.

Example:

    IF(
        LOOKUPVALUE(Rules[Code], Rules[SupplierIDCode], Data[SupplierIDCode], Rules[SupplierID], Data[SupplierID]) = Data[Code]
        ,
        LOOKUPVALUE(Rules[NewCategory],Rules[Code],Data[Code]) & "From Rules"
        ,
        LOOKUPVALUE(Suppliers[DefaultCategory],Suppliers[SupplierID],Data[SupplierID])
    )

Forum Discussion

Help witch fetching values from another table depending on conditions

10 Replies

Related content

Circular dependency

Error fetching data

Error Fetching Data

Error fetching data

Fetch licences information