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 am trying to build a function returning the highest (most recent) date for this column between two columns and i receive an error telling me trans effective date cannot be determined? Is there something wrong with the formatting of my data?
This is the function I am trying to mirror from qlik-view:
@jbluhm Wrap your column references in MAX functions as well. That form of the MAX function takes expressions and since you are referencing columns, you need to aggregate them.
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 |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |