Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
RPNancy54
Helper I
Helper I

Roundup 0,05

Hello,

 

Someone can help me please ?

Roundup to 0,05 ???

What the mesure ?

RPNancy54_0-1663708424032.png

Thanks

7 REPLIES 7
Greg_Deckler
Super User
Super User

@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

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

RPNancy54_0-1663735378887.png

 

@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))

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Hello,

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.


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Hello,

Do you have a moment for me please ?

Thanks

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.