Hi there,
So I have table called chapter in which it has all the select columns with decimals I want to make a slice and in the slice I want to know the Highest number in tha table the number is decimal
Thanks in advance
Use a MAX(Select(… formula to get this
Can you give me a bit more information
Let’s say your slice name is mySlice
your column with decimals is myDecimals
So, the dereference expression: mySlice[myDecimals]
will gives a list of all the decimals in your slice.
So, the expression you are looking for is:
MAX(mySlice[myDecimals])
For further information (I suggest you read it):
But here I am not using slice I am using the virtual columns to get the sum total when I am using MAX(TABLENAME[COLUMN NAME]) i am getting error should return true or false
You must be consistent in your request.
That’s probably because you set the column type as being Yes/No ?
What if you change it to being Decimal instead ?
Nope I am getting same error
Can you please share screenshots of:
Thanks for sharing.
From what I see, you are not familiar with row filter condition and slices.
I strongly invite you to have a look there:
Can you explain with plain text what you are trying to achieve with this slice ?
User | Count |
---|---|
43 | |
30 | |
26 | |
14 | |
14 |