I have a large table with a number of values in a field that have 3-6 decimal places - I would like to see/extract these rows only. Is there a way I can do this using filters in Power BI Desktop?
Go to Solution.
Maybe you could try this formula as a calculated column. Please test it before using it.
VAR NumOfDecimal =
[Column1] = TRUNC ( [Column1] ),
LEN ( [Column1] ) - LEN ( TRUNC ( [Column1] ) )
IF ( NumOfDecimal >= 3 && NumOfDecimal <= 6, 1, 0 )
View solution in original post
The way I would go about it is to go into the Query Editor and do the following:
Then in your report view you could use this as filter or slicer in your data.
Proud to be a Super User!
Could you please mark the proper answer if it's convenient for you? That will be a help to others.
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.