Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I need to filter using USERCULTURE(), I need to have the item of the table for filter , but I need they change by language of user?
If I try to use USERCULTURE(), power bi say me I can't use it in a column!
Solved! Go to Solution.
Hello @Robbiema ,
For your first question, the return value of the function USERCULTURE() is fixed in the form of language-country. You want to use the return value of USERCULTURE() to match the user's language. Based on what I have learned so far, this cannot be achieved.
For more information on how to use USERCULTURE(), you can check this document
USERCULTURE function (DAX) - DAX | Microsoft Learn
For your second question, the function of USERCULTURE() is to dynamically display different date formats or currency units according to the user's region, so USERCULTURE() can only be used in measure.
So if you want to use USERCULTURE(),Please use it in measure.
Best Regards,
Jayleny
Hello @Robbiema ,
For your first question, the return value of the function USERCULTURE() is fixed in the form of language-country. You want to use the return value of USERCULTURE() to match the user's language. Based on what I have learned so far, this cannot be achieved.
For more information on how to use USERCULTURE(), you can check this document
USERCULTURE function (DAX) - DAX | Microsoft Learn
For your second question, the function of USERCULTURE() is to dynamically display different date formats or currency units according to the user's region, so USERCULTURE() can only be used in measure.
So if you want to use USERCULTURE(),Please use it in measure.
Best Regards,
Jayleny
User | Count |
---|---|
77 | |
74 | |
63 | |
61 | |
45 |
User | Count |
---|---|
108 | |
102 | |
93 | |
83 | |
64 |