Roundup 0,05

[RPNancy54]

Hello,

Someone can help me please ?

Roundup to 0,05 ???

What the mesure ?

Thanks

[Greg_Deckler]

@RPNancy54 Try this:

Column = 
    VAR __Table = ADDCOLUMNS(GENERATESERIES([Column1],[Column1]+.05,.01),"Mod",[Value] - 0.05*INT([Value]/.05))
    VAR __Min = MINX(FILTER(__Table,[Mod]<=0),[Value])
RETURN
    __Min

[RPNancy54]

[Greg_Deckler]

@RPNancy54 If I translated that correctly it says that the arguments for the GENERATESERIES function cannot be empty. Do you have a blank row for your Mesure somewhere? If that is the case, you could wrap the whole thing in an IF statement where you check if Mesure is blank (ISBLANK() or [Mesure] = BLANK() ) and if so just return a 0. Or you could just use a +0 like this:

VAR __Table = ADDCOLUMNS(GENERATESERIES([Column1] + 0,[Column1]+.05,.01),"Mod",[Value] - 0.05*INT([Value]/.05))

[RPNancy54]

Hello,

Thank you.

Where i paste this ? DAX, Power Query, ... ?

Have a nice day

[Greg_Deckler]

@RPNancy54 It's DAX see message above on how to fix and account for having blank rows for your value column.

[RPNancy54]

Hello,

Do you have a moment for me please ?

Thanks

[RPNancy54]

Hello,

Again thank you.

It' no good : 

Q4 roundup 0,05 =

    VAR __Table = if(ISBLANK([Mesure]),0, ADDCOLUMNS(GENERATESERIES([Mesure],[Q4 Mesuré]+.05,.01),"Mod",[Value] - 0.05*INT([Value]/.05))

    VAR __Min = MINX(FILTER(__Table,[Mod]<=0),[Value]))

RETURN

    __Min

Do you know why ?

Yhank you