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…
Solved! Go to 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)))
You can have an enum type column with base-type number for the drop-down.
@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
)
@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)))
User | Count |
---|---|
35 | |
35 | |
28 | |
23 | |
18 |