Hello everyone! I am doing a valid If to show a drop-down list related to today's date SELECT(SCHEDULE[LIST], [DATE] = TODAY()) but I would like there to be an exception for a specific Country that was previously selected in User Settings And for that country the entire list of the [SCHEDULE] table is shown, as I would do the expression I have tried to do but without success ... Thanks for your Help
Solved! Go to Solution.
IF(
[_THISUSER].[COUNTRY]<>"THE_COUNTRY",
SELECT(SCHEDULE[LIST], [DATE] = TODAY()),
SCHEDULE[LIST]
)
IF(
[_THISUSER].[COUNTRY]<>"THE_COUNTRY",
SELECT(SCHEDULE[LIST], [DATE] = TODAY()),
SCHEDULE[LIST]
)
Thank you very much for your time and help!
User | Count |
---|---|
15 | |
14 | |
8 | |
7 | |
4 |