Forum Discussion

RPNancy54's avatar
RPNancy54
Helper I
3 years ago

Roundup 0,05

Hello,   Someone can help me please ? Roundup to 0,05 ??? What the mesure ? Thanks
Need Help
RPNancy54's avatar
RPNancy54
Helper I
3 years ago

Hello,

Thank you.

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

Have a nice day

Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

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

  • RPNancy54's avatar
    RPNancy54
    Helper I
    3 years ago

    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
  • RPNancy54's avatar
    RPNancy54
    Helper I
    3 years ago

    Hello,

    Do you have a moment for me please ?

    Thanks