Bring third dependent column if it is a number type?

Hi,

Is it possible to bring third depended drop-down list if the column type is number?
The Column type should be Number to make to calculations?

Thanks for help…

You can have an enum type column with base-type number for the drop-down.

1 Like

@Heru thank you for your suggestion,

I think I have made it but there is one problem with my table that I didn’t figure it out how to solve.

As seen in my projects table I have project bloc and logements column, dropdown working correct for the projects and the bloc columns. I want to bring logegements column for its dependencies as default. What kind expression I should write for valid_if constraints.

Something like:

SELECT(
  MyProjectTable[LOGMENTS],
  AND(
    ([_THISROW].[PROJECT] = [PROJECT]),
    ([_THISROW].[BLOC] = [BLOC])
  ),
  TRUE
)
3 Likes

@Heru, thank you for your help…

I have made it by using the formula below…
IN([_THIS],
SELECT(PROJECTS[LOGEMENT],
AND(
([_THISROW].[PROJECT] = [PROJECT]),
([_THISROW].[BLOC] = [BLOC]),
TRUE)))

2 Likes