Forum Discussion
zero left
Hi acarlos
You can use my blog post, which will add the required amount of zero's to your data.
To complete it, you will need to make the changes in the Power Query Editor (Edit Queries) window
https://www.fourmoo.com/2015/03/25/power-query-adding-leading-zero-to-number-eg-month-number/
I need a numerical field with leading zeros to use a filter between two values:
000001,00002,00003,....,000099,000100
select 000040 between 000050 for example
so the field has to be numerical with leading zeros but power bi does not allow this formatting
if field is text only allows filter in list without intervals
Hi acarlos
You can use my blog post, which will add the required amount of zero's to your data.
To complete it, you will need to make the changes in the Power Query Editor (Edit Queries) window
https://www.fourmoo.com/2015/03/25/power-query-adding-leading-zero-to-number-eg-month-number/