Forum Discussion

Advocate I

4 years ago

Solved

Dynamic Table in Power BI

I need to create a dynamic table upon load. For example, I am developing our finance dashboard where all account codes that start with 100 are part of the "ASSETS" group. So, when the data is refre...

Need Help

Anonymous
4 years ago
Hi lfholland,

I think you need to create a parameter that stored the rule to remark records, then you can add a calculated column to your fact table and lookup at the above parameter table rules, and compare with the current row value to setting corresponding groups.

SWITCH function (DAX) - DAX | Microsoft Docs

From SQL to DAX: String Comparison - SQLBI

Regards,

Xiaoxin Sheng

Anonymous

Not applicable

4 years ago

Hi lfholland,

I think you need to create a parameter that stored the rule to remark records, then you can add a calculated column to your fact table and lookup at the above parameter table rules, and compare with the current row value to setting corresponding groups.

SWITCH function (DAX) - DAX | Microsoft Docs

From SQL to DAX: String Comparison - SQLBI

Regards,

Xiaoxin Sheng