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

 

 

Need Help

4 Replies

  • 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.

     

  • 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.

     

     

     

     

     

  • AlB's avatar
    AlB
    Community Champion
    3 years ago

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

      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.