Add Bi-weekly pay date to calendar

[4008040]

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 on my own so I am hoping someone ho sees this can help.

[AlB]

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.

[4008040]

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.

[4008040]

Hi @AlB 

I can't seem to be able to use Number.Ceiling. Am I getting something wrong here? It doesn't seem to show up in desktop or web for me.

[AlB]

Hi @4008040 

There's a very similar function in M:
Number.Ceiling(number as number, optional precision 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.