createOrReplace

	table Dim_Date
		lineageTag: e57db031-9375-4a8b-a91a-91fbad5f05ba
		dataCategory: Time

		column Date
			isKey
			formatString: Long Date
			lineageTag: 7196cbd7-b073-4077-b598-3cf3b1453c2e
			summarizeBy: none
			isNameInferred
			sourceColumn: [Date]

			annotation SummarizationSetBy = Automatic

			annotation UnderlyingDateTimeDataType = Date

		column Année
			formatString: 0
			lineageTag: e7273cf8-0212-497f-9f7a-db88f7c6fae1
			summarizeBy: sum
			isNameInferred
			sourceColumn: [Année]

			annotation SummarizationSetBy = Automatic

		column Trimestre
			lineageTag: e717c781-61e2-4ccf-b924-3137317baf9a
			summarizeBy: none
			isNameInferred
			sourceColumn: [Trimestre]

			annotation SummarizationSetBy = Automatic

		column NumMois
			formatString: 0
			lineageTag: 7d589779-4e1f-4864-8e48-9295b0da0f03
			summarizeBy: sum
			isNameInferred
			sourceColumn: [NumMois]

			annotation SummarizationSetBy = Automatic

		column Mois
			lineageTag: db40e797-0f1a-4185-8082-eee7cac33f6a
			summarizeBy: none
			isNameInferred
			sourceColumn: [Mois]
			sortByColumn: NumMois

			annotation SummarizationSetBy = Automatic

		column Semestre
			lineageTag: 820253d2-330a-4aff-b43a-40bde6cd9237
			summarizeBy: none
			isNameInferred
			sourceColumn: [Semestre]

			annotation SummarizationSetBy = Automatic

		column JourDansSemaine
			formatString: 0
			lineageTag: 5a5f4390-eb0d-4495-94ae-5a1ab806e708
			summarizeBy: sum
			isNameInferred
			sourceColumn: [JourDansSemaine]

			annotation SummarizationSetBy = Automatic

		column JourOuvre/NonOuvre
			lineageTag: 54268fba-99fc-454a-9d6c-e5eebf2332c0
			summarizeBy: none
			isNameInferred
			sourceColumn: [JourOuvre/NonOuvre]

			annotation SummarizationSetBy = Automatic

		column Semaine_Intevalle
			lineageTag: 37e4e7bf-f37b-4247-b5d9-5bd9bd9359d2
			summarizeBy: none
			isNameInferred
			sourceColumn: [Semaine_Intevalle]

			annotation SummarizationSetBy = Automatic

		column Num_Semaine = WEEKNUM(Dim_Date[Date],21)
			formatString: 0
			lineageTag: 148cba9e-c0ff-424d-960b-c4a1d30839fd
			summarizeBy: sum

			annotation SummarizationSetBy = Automatic

		column FiscalYearMars = if(Dim_Date[NumMois]>=4,Dim_Date[Année]+1,Dim_Date[Année])
			formatString: 0
			lineageTag: 72e29404-ca5f-4d5a-a9aa-45e2c3148bb0
			summarizeBy: sum

			annotation SummarizationSetBy = Automatic

		column 'Semaine du Mois' = INT( (DAY(Dim_Date[Date]) - 1) / 7 ) + 1
			formatString: 0
			lineageTag: 5bdb0cd6-537e-435b-ab94-e567735e45c0
			summarizeBy: sum

			annotation SummarizationSetBy = Automatic

		column 'Nom Jour' = ```
				FORMAT(Dim_Date[Date], "dddd")
				
				```
			lineageTag: 4f533cc4-35fa-4426-948b-7d6f065737fe
			summarizeBy: none
			sortByColumn: JourDansSemaine

			annotation SummarizationSetBy = Automatic

		hierarchy Hierarchie_date
			lineageTag: fca8c120-e31b-49a8-ac00-96b5827389be

			level Année
				lineageTag: 2d23a1b9-48df-49e4-9b1d-df2cc0e7ba68
				column: Année

			level Trimestre
				lineageTag: 3ac8d74d-41b9-423e-89e2-d786c53e90c5
				column: Trimestre

			level Mois
				lineageTag: c3ced109-97f6-4ea6-b86e-9b1163b8e8bc
				column: Mois

			level Date
				lineageTag: e43d8f62-e5d3-4ddd-ad2b-1e05b3776474
				column: Date

		partition Dim_Date = calculated
			mode: import
			source = ```
					ADDCOLUMNS(CALENDARAUTO(), 
					"Année", YEAR([Date]), 
					"Trimestre", "T"&  QUARTER([Date]),
					"NumMois", MONTH([Date]),
					"Mois", FORMAT([Date], "mmmm"),
					"Semestre", IF(MONTH([Date]) > 6 , "S2", "S1"),
					"JourDansSemaine", WEEKDAY([Date], 2),
					"JourOuvre/NonOuvre" , IF(WEEKDAY([Date],2) > 5, "Non ouvré","Jour Ouvré"),
					"Semaine_Intevalle",
					VAR DateActuelle = [Date]
					VAR Lundi = DateActuelle - WEEKDAY(DateActuelle,2) + 1
					VAR Dimanche = Lundi + 6
					RETURN
					FORMAT(Lundi, "dd/mm/yyyy") & " - " & FORMAT(Dimanche, "dd/mm/yyyy")
					)
					```