Forum Discussion
Roundup 0,05
Hello,
Someone can help me please ?
Roundup to 0,05 ???
What the mesure ?
Thanks
7 Replies
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.
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))
