Forum Discussion

4008040's avatar
4008040
Frequent Visitor
3 years ago

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...
Need Help
AlB's avatar
AlB
Community Champion
3 years ago

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.