Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
I have a group by function with text, numbers, dates and logicals, but I need some of the numbers to be integers.
It's easy enough to add a "change type" step after the grouping, but I can't help feeling there is a shorter way of doing it.
At the moment, I have this clause:
"statusId", each List.Max([statusId]), type nullable number"
but I really want is something like:
"statusId", each List.Max([statusId]), type nullable integer"
Is this possible? Or do I have to stick the two-step process?
Solved! Go to Solution.
Hi
... type nullable Int64.Type...
Stéphane
| User | Count |
|---|---|
| 4 | |
| 4 | |
| 2 | |
| 2 | |
| 2 |
| User | Count |
|---|---|
| 15 | |
| 6 | |
| 6 | |
| 5 | |
| 5 |