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.
why cant i write VALUES('calendar'[MonthName]) and drag this is a matrix and see the unqiue values of that column. Isnt this function supposed to return the unqiue values of a column within a table?
Solved! Go to Solution.
No. Values function cannot be used directly to return result. It's use is limited as intermediate function, nested within another function.
Ex:
=COUNTROWS(VALUES('calendar'[MonthName]))
If you stick the column into rows of Matrix. It will automatically aggregated/grouped by distinct.
Then you can add measures to summarize data based on it.
Though I'm not sure what end result you are after.
No. Values function cannot be used directly to return result. It's use is limited as intermediate function, nested within another function.
Ex:
=COUNTROWS(VALUES('calendar'[MonthName]))
If you stick the column into rows of Matrix. It will automatically aggregated/grouped by distinct.
Then you can add measures to summarize data based on it.
Though I'm not sure what end result you are after.
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 |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |