WeekNum vs Month

[Chandrashekar]

Hello,

am looking for column formula. If week number continuous to next month I need to get previous month.

Link: Sample file 

Regards,

Chandrashekar B

[aduguid]

Can you post an example of what you expect to see?

[Chandrashekar]

Hello,

Expected result is in sample pbix file(already shared). am looking for column formula(new column) If week number continuous to next month I need to get previous month.

Link: Sample file 

Regards,

Chandrashekar B

[Anonymous]

Hi @Chandrashekar 

Your files are set with access permissions, and I'm requesting access.

Best Regards

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

[Chandrashekar]

Hello,

Please check below link.

Sample File: Sample File 

Regards,

Chandrashekar B

[Anonymous]

Hi @Chandrashekar 

Please try this:

Create a calculated column:

Column =
FORMAT (
    CALCULATE (
        MIN ( 'Table'[Month] ),
        FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Week] = EARLIER ( 'Table'[Week] ) )
    ),
    "MMM-YY"
)

The result is as follow:

Best Regards

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

[Chandrashekar]

Thank you it is working perfectly. Can you please explain how it works in steps please.

Regards,

Chandrashekar B

[Anonymous · Accepted solution]

Hi @Chandrashekar 

I added the comment:

Column = 

VAR _A = CALCULATE (
        MIN ( 'Table'[Month] ),
        FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Week] = EARLIER ( 'Table'[Week] ) )
    )
    //Get the min date of every week, for examnple, the 16th week is 2024-04-15
RETURN FORMAT(_A,"MMM-YY")
//format the column to "MMM-YY"

 The outcome of variable _A:

Best Regards

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