Forum Discussion

loodle's avatar
loodle
Frequent Visitor
4 years ago
Solved

Help with MTD Measure

Just trying to use the MTD function for the following data:   Record Number Repair Date Status 1 1/1/2022 Closed 2 3/4/2022 Closed 3   Active 4 3/4/2022 Closed 5 3/18/2...
Need Help
  • NickolajJessen's avatar
    NickolajJessen
    4 years ago

    Haha, i don't understand these MTD formulas at all 😂

    How about something more lowkey like:

    This month = 
CALCULATE(
    DISTINCTCOUNT('Tabel (2)'[Record Number])
    ,FILTER('Calendar', 
        'Calendar'[Date] <= EOMONTH(TODAY(),0)
        && 'Calendar'[Date] >= (EOMONTH(TODAY(),-1)+1)

    )
)

    Should give you data between 01-06-2022 and 31-06-2022


loodle's avatar
loodle
Frequent Visitor
4 years ago

This seemed to work, thanks. Now I want to add YTD, struglling to understand the difference between EOMONTH and ENDOFMONTH, and the is no EOYEAR. 

v-chenwuz-msft's avatar
v-chenwuz-msft
Community Support
4 years ago

Hi loodle,

 

Very happy that your problem was solved. Please mark it as a solution.
About YTD, you can recreate a post so that you can get better help.

 

EOMONTH

  • Specify a start date. Before or after a few months and return the last day of the month. for example a table with date column from 1/1/2022 to 1/13/2022, 1 month after 1/1/2022, result of EOMONTH is 2/28/2022.

 

ENDOFMONTH 

  • get the last date of current context. for example a table with date column from 1/1/2022 to 1/13/2022, then ENDOFMONTH() return 1/13/2022 rather than 1/31/2022

 

Best Regards

Community Support Team _ chenwu zhu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.