Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
53 | |
35 | |
20 | |
16 | |
15 |
User | Count |
---|---|
94 | |
74 | |
30 | |
22 | |
16 |