Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have the following DAX code in my PBI file. I have only changed the data sources from .xlsx files to .csv files. All the data and datatypes are identical. After changing the data sources though, this code gives me an error:
MAX_User =
CALCULATE(
MAXX(
ALLSELECTED('CALC NP''s (Unique)'),
'CALC NP''s (Unique)'[User]
),
GROUPBY(
'CALC NP''s (Unique)',
Date[Week],
'CALC NP''s (Unique)'[Patiëntnumber]
)
)
For 'Date[Week]' it now suddenly says 'Parameter is not the correct type'. Does anyone have an idea of why this is?
Solved! Go to Solution.
@Sohan , Check your relationships. I think that has broken, It may happen when changes sources from one type to another
@Sohan , Check your relationships. I think that has broken, It may happen when changes sources from one type to another
Thank you so much! The relationship was indeed broken for some reason.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |