Forum Discussion

CGRPTAS's avatar
CGRPTAS
Frequent Visitor
9 years ago
Solved

Calendar Table MTD, Nextday & Previousday

Hi, I am trying to utilise the MTD function in Powerbi to return daily budget numbers to the current month to date, however am receiving numbers for the entire month.  I have a Calendar table with d...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi CGRPTAS,

     

    MTD function will return a table that contains a column of the dates for the month to date.(in the current context).

     

    For example:

     

     

    This function often used to calculate the monthly rolling total. You can combination use DATESMTD function and LASTDATE function to get the current date.

    Formula:

    LASTDATE(DATESMTD('Date Table'[Date]))

     

    In addition, if you want to get the current date by measure, you can simply use max or min function to get it.

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi CGRPTAS,

 

MTD function will return a table that contains a column of the dates for the month to date.(in the current context).

 

For example:

 

 

This function often used to calculate the monthly rolling total. You can combination use DATESMTD function and LASTDATE function to get the current date.

Formula:

LASTDATE(DATESMTD('Date Table'[Date]))

 

In addition, if you want to get the current date by measure, you can simply use max or min function to get it.

 

Regards,

Xiaoxin Sheng

CGRPTAS's avatar
CGRPTAS
Frequent Visitor
9 years ago

Thank you Xiaoxin Sheng, That has resolved my issue, appreciate your detailed explanation. 

Cheers!