We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now
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.
@Anonymous , 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.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 53 | |
| 38 | |
| 33 | |
| 17 | |
| 17 |
| User | Count |
|---|---|
| 67 | |
| 62 | |
| 38 | |
| 34 | |
| 22 |