How can I change values in a calculated column?

[Mons_Aku]

Hi! I have a calculated column "Days To Ship" (a product) with data type "Whole number".  Some values here are incorrect for example -34568. Every value has to be at least 1.

I want to create a Gauge:

and I can't use the "Filters" panel.

Can someone please help me? Thank you in advance!

[IoannisPhilip]

Hi @Mons_Aku ,

You can go to the fields panel, click the 3 dots, and then "edit query". Then you click on the gear icon next to "source".

This will open your table in an edible version, where you can double-click on the entry you want to alternate manually.

All this assuming that you know which are the right values. Alternatively, you can just apply a filter only on the specific visual with data being "greater or equal to" 1. 

Let me know if I can support you further.

Best of luck,
Ioannis

[Mons_Aku]

Thank you, but as I said I can't use the Filter panel since It's a Gauge visual and nor the Source since It's a calculated column. It doesn't show in Power Query Editor.

[Greg_Deckler]

@Mons_Aku What is your formula?

[Mons_Aku]

For my calculated column?

DaysToShip = Orders[ShippedDate] - Orders[OrderDate]

You can see the incorrect values above.

[FreemanZ]

hi @Mons_Aku 

try like,

DaysToShip = 

VAR _value =

Orders[ShippedDate] - Orders[OrderDate]

RETURN

IF(_value<1, 1, _value)

[Akuhei05]

That was it! Thank you!