topic Re: WeekNum vs Month in DAX Commands and Tips

WeekNum vs Month

Chandrashekar — Tue, 14 May 2024 05:18:17 GMT

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

Re: WeekNum vs Month

aduguid — Tue, 14 May 2024 05:33:13 GMT

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

Re: WeekNum vs Month

Chandrashekar — Tue, 14 May 2024 05:49:19 GMT

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

Re: WeekNum vs Month

Anonymous — Wed, 15 May 2024 05:07:19 GMT

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.

Re: WeekNum vs Month

Chandrashekar — Wed, 15 May 2024 05:08:57 GMT

Hello,

Please check below link.

Sample File: Sample File

Regards,

Chandrashekar B

Re: WeekNum vs Month

Anonymous — Wed, 15 May 2024 05:26:10 GMT

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.

Re: WeekNum vs Month

Chandrashekar — Wed, 15 May 2024 05:36:47 GMT

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

Regards,

Chandrashekar B

Re: WeekNum vs Month

Anonymous — Wed, 15 May 2024 05:50:26 GMT

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.