Forum Discussion

NavaneethaRaju's avatar
3 years ago
Solved

Need Help with Dax- Interview Question

Hi,  I just shared the interview question that asked to me during on the interview.    Consider we have only 2 dates.  Date:--------Previous Month 09/01/2022-  Dec 09/02/2022- Jan   W...
  • FreemanZ's avatar
    3 years ago

    hi NavaneethaRaju 

    what about:

    Measure or Column = EDATE ( 'Table'[Date], -1 )

    or

    = MONTH( EDATE ( 'Table'[Date], -1 ))