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
4008040's avatar
4008040
Frequent Visitor
3 years ago

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.