Forum Discussion
Roundup 0,05
Hello, Someone can help me please ? Roundup to 0,05 ??? What the mesure ? Thanks
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
__MinHello,
Thank you.
Where i paste this ? DAX, Power Query, ... ?
Have a nice day
RPNancy54 It's DAX see message above on how to fix and account for having blank rows for your value column.
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__MinDo you know why ?Yhank you
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))
