Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
__Min
@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))
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.
Hello,
Do you have a moment for me please ?
Thanks
Hello,
Again thank you.
It' no good :
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |