How to format a measure or column in Dax to remove 0 values, current format is in Euro Values 0,00

[Anonymous]

HI All, 

I am trying to remove 0 from a measure/Column results, current EUR vales are 0,00, so the comma is acting a a divider in a  Format Function. Example below:

=(SUMIFS(Reve[Revenue], 'Filter'[column], "Filter")

Any ideas here to remove the 0,00 in a filter?

[GilbertQ · Accepted solution]

Hi @Anonymous 

When you import the data using Power Query, you can change the data type at the top to whole number.

[GilbertQ]

Hi @Anonymous 

Could you perhaps change the data type on your current column to be a whole number You could then use the formatting options to put in their commas so that it is not stored as part of the number.

[Anonymous]

How would I go about doing that?