cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Regular Visitor

## Calendar

Can you do one of calendars and how to put from/to week. Example: I have a list of dates from 8/27 to 9/2 and on another column I need that for those dates says 8/27 - 9/2, can that be done?
1 ACCEPTED SOLUTION
Community Support

Create three calculated columns as below

```year = YEAR([date])

weeknum = WEEKNUM([date],2)

date custom =
CONCATENATE (
CONCATENATE (
FORMAT (
CALCULATE (
MIN ( [date] ),
ALLEXCEPT ( Sheet8, Sheet8[year], Sheet8[weeknum] )
),
"m/dd"
),
"-"
),
FORMAT (
CALCULATE (
MAX ( [date] ),
ALLEXCEPT ( Sheet8, Sheet8[year], Sheet8[weeknum] )
),
"m/dd"
)
)```

Best Reagrds

Maggie

2 REPLIES 2
Community Support

Create three calculated columns as below

```year = YEAR([date])

weeknum = WEEKNUM([date],2)

date custom =
CONCATENATE (
CONCATENATE (
FORMAT (
CALCULATE (
MIN ( [date] ),
ALLEXCEPT ( Sheet8, Sheet8[year], Sheet8[weeknum] )
),
"m/dd"
),
"-"
),
FORMAT (
CALCULATE (
MAX ( [date] ),
ALLEXCEPT ( Sheet8, Sheet8[year], Sheet8[weeknum] )
),
"m/dd"
)
)```

Best Reagrds

Maggie

Regular Visitor

Thanks Maggie...I did something with the formula to present it more organized:

Weekfromto =

VAR Desde = format(Calculate(min('Calendar Table'[Date]),ALLEXCEPT('Calendar Table','Calendar Table'[Year],'Calendar Table'[Week#])),"mmm-dd-yy")

VAR Hasta = format(Calculate(max('Calendar Table'[Date]),ALLEXCEPT('Calendar Table','Calendar Table'[Year],'Calendar Table'[Week#])),"mmm-dd-yy")

RETURN

Desde &" - "& Hasta

Desde means From and Hasta means Through

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors