The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi all,
I am new to DAX expressions and am trying to work out the current academic year based on the start and end dates. I have managed to write a dax expression in DAX studio using filter() function which returns the result expect but when I apply this to a measure in Power BI Desktop I get the error message "too many arguments were passed to the filters function. The maximum argument count for the function is 1)".
Could someone help and advise what I'm doing wrong?
example of the table
dax formula created
Error in Power BI desktop
Thanks
Monju
I tried with FILTER() too and am still getting the same error.
That doesn't make sense. It should at least give a different error since FILTER expects two arguments.
Apologies, the message is slightly different. I'm a confused as to why the dax expression works in DAX studio but not in Power Bi.
Are you defining CYOE as a calculated table? The error makes me think you are trying to define a measure or a calculated column with a table definition, which doesn't make sense.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
61 | |
32 | |
20 | |
15 | |
15 |
User | Count |
---|---|
94 | |
33 | |
30 | |
24 | |
21 |