Forum Discussion
Roundup 0,05
Hello, Someone can help me please ? Roundup to 0,05 ??? What the mesure ? Thanks
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
__Min
Do you know why ?
Yhank you