Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I'm trying to create a table which shows the top N entities that experienced the largest amount of change relative to the previous month (actual quantities or percentage change, doesnt matter). I have tried the following DAX query but it doesnt work because one of the columns carries string types.
maybe you need convert the data type of [model breach] from text to number
but the data in that column are all strings, is there another formula or solution to this type of problem?
User | Count |
---|---|
42 | |
28 | |
23 | |
18 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
17 | |
15 |