Forum Discussion
Add Bi-weekly pay date to calendar
Hi I currently use CEILING in DAX to add a payday column to a calendar table. I'm looking for a way to do the same in Power Query so I can build pay calendars all in one go. I haven't found a way...
Try this instead
Number.RoundUp(number as nullable number, optional digits as nullable number)
|
|
Please accept the solution when done and consider giving a thumbs up if posts are helpful. Contact me privately for support with any larger-scale BI needs, tutoring, etc. |
Thanks for the suggestion, Number.RoundUp doesn't do the same as the DAX Ceiling. I'm just going to stick with the Dax solution for now.