Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Display months based on days

How can I display months based on the first Monday of each month?? For example August 21 should be from 02/08/2021 - 05/09/2021 I have calculated the iso week based on WEEKNUM([Date],21), so what I...
Need Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    4 years ago

    Hi, Anonymous 

     

    After my test, I create a calculated column to diaplay the monthnum you want.

    Like this:

    monthnum = 
MAXX (
    FILTER (
        'Table',
        [Date] <= EARLIER ( 'Table'[Date] )
            && IF ( WEEKDAY ( [Date], 2 ) = 1, ( MONTH ( [Date] ) ) )
                <> BLANK ()
    ),
    IF ( WEEKDAY ( [Date], 2 ) = 1, ( MONTH ( [Date] ) ) )
)

    Did I answer your question ? Please mark my reply as solution. Thank you very much.
    If not, please feel free to ask me.


    Best Regards,

    Community Support Team _ Janey

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

Hi, Anonymous 

 

After my test, I create a calculated column to diaplay the monthnum you want.

Like this:

monthnum = 
MAXX (
    FILTER (
        'Table',
        [Date] <= EARLIER ( 'Table'[Date] )
            && IF ( WEEKDAY ( [Date], 2 ) = 1, ( MONTH ( [Date] ) ) )
                <> BLANK ()
    ),
    IF ( WEEKDAY ( [Date], 2 ) = 1, ( MONTH ( [Date] ) ) )
)

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.


Best Regards,

Community Support Team _ Janey

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thank you very much v-janeyg-msft