Forum Discussion

noah44's avatar
noah44
Helper I
5 years ago
Solved

Getting Month and Year from a Datetime field with DirectQuery

Hello,   I have a report where I want to show hourly, daily, monthly and yearly data.   It all worked fine expect for the monthly overview.   I tried it like this: DATEVALUE(MONTH(smrt_eigenv...
Need Help
  • noah44's avatar
    noah44
    5 years ago

    Hi, 

     

    thanks for your answers. Sadly they both did not work.

    But I found a solution that works for me:

     

    DATE(YEAR('Table'[date]), MONTH('Table'[date]), 1)

     

    Best Regards

    Noah

Pragati11's avatar
Pragati11
Super User
5 years ago

Hi noah44 ,

 

Have you tried something like this:

Date MMYYYY = FORMAT(ClothingSales[Date],"mmm-yyyy")
 
This calculation will also give you Month-Year part.
 
Thanks,
Pragati
  • noah44's avatar
    noah44
    Helper I
    5 years ago

    Hi Pragati11,

     

    I tried this a while ago but apparently FORMAT can not be used with DirectQuery.

     

    Thanks for your answer