Forum Discussion

Sam7's avatar
Sam7
Icon for Advocate II rankAdvocate II
4 years ago
Solved

How do I give each date a number

I have two date columns, Exam Booking Date: The date the exam was booked and fees paid. Exam Date is when the examination will take place.  This can be upto 18 months in the future.    How can I co...
Need Help
  • TomMartens's avatar
    TomMartens
    4 years ago

    Hey Sam7 ,

     

    almost everything you need to know about date calculations is here: Time patterns – DAX Patterns

    You need to create a dedicated calendar table, then relate this calendar table to the booking date and you will be able to use time intelligence functions like PREVIOUSMONTH – DAX Guide

     

    I assume that you one table that contains the bookings, if not - use Power Query to create a single table using the append operation.

     

    Regards,

    Tom

TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
4 years ago

Hey Sam7 ,

 

almost everything you need to know about date calculations is here: Time patterns – DAX Patterns

You need to create a dedicated calendar table, then relate this calendar table to the booking date and you will be able to use time intelligence functions like PREVIOUSMONTH – DAX Guide

 

I assume that you one table that contains the bookings, if not - use Power Query to create a single table using the append operation.

 

Regards,

Tom