Skip to main content
Microsoft Idea

Power BI

Completed

relationship with wildcards

Vote (3) Share
's profile image

on 15 Oct 2019 13:34:46

Would like to have the functionality that you are able to build a relationship using wild cards, eg:

Dimension:
Key: P001*Y2*****GT7777
Key: P001**************

FACT:
Key: P0011Y2H22323GT6543

The relationship to take into consideration the wildcards so that I can classify a line item to multiple times.

Administrator on 09 Dec 2020 00:41:22

Please use a calculated column to achieve this.