Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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?
Solved! Go to Solution.
Hi @checkstatap
When you import the data using Power Query, you can change the data type at the top to whole number.
Hi @checkstatap
When you import the data using Power Query, you can change the data type at the top to whole number.
Hi @checkstatap
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.
How would I go about doing that?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.