Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Good Morning. In the free version , as we separate the number shown in the graph in hundreds?
For example , instead of my number appear as " 1211 " appears as " 1.211 "?
Thanks 😉
Solved! Go to Solution.
@deisedc If "0027812-38.2005.8.26.0100" is your value, are you trying to extract only a portion of that for each row? I'm trying to understand how you are able to return anything using COUNT(NUMERO_PROCESSO) since it is a text field. You would need to use COUNTA(NUMERO_PROCESSO) if you wanted to count the number of times a value is present.
If you want to SUM NUMERO_PROCESSO then you need to reformat the value to be a valid number and change the data type...
I might not be understanding the specific issue/problem..
@deisedc The desktop is free for everyone. Are you having an issue in the Service? (app.powerbi.com) - or the Desktop?
If it is the Desktop, if you go to the "Data" section and click "Modeling" and highlight the column, what is the data type and format of the column?
It's a Desktop version and the data type is a text. I have applied COUNT(NUMERO_PROCESSO) and it has returned a number. But this number doesn't accept the format. Example of data in the field NUMERO_PROCESSO = 0027812-38.2005.8.26.0100.
Could you help me?
Thank you!
@deisedc If "0027812-38.2005.8.26.0100" is your value, are you trying to extract only a portion of that for each row? I'm trying to understand how you are able to return anything using COUNT(NUMERO_PROCESSO) since it is a text field. You would need to use COUNTA(NUMERO_PROCESSO) if you wanted to count the number of times a value is present.
If you want to SUM NUMERO_PROCESSO then you need to reformat the value to be a valid number and change the data type...
I might not be understanding the specific issue/problem..