Bring third dependent column if it is a number type?

[Atlas]

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…

[hru]

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

[Atlas]

@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.

[hru]

Something like:

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

[Atlas · Accepted solution]

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