help..create a calcuated column in date table

Question

hi ,&nbsp;i have date table like below. what&nbsp; am trying to do is to create calculated columns for'fiscal_yr_startdate, fiscal_yr_enddate, fiscal_qtr_startdate,fiscal_qtr_enddate, fiscal_month_startdate, fiscal_month_startdate, fiscal_week_startdate, fiscal_week_enddate. Please suggest.&nbsp;&nbsp;Jihwan_Kim&nbsp;Calender_date,&nbsp; &nbsp; CLNDR_YR_NBR,&nbsp; &nbsp;FISCL_YR_NBR,&nbsp; CLNDR_QTR_NBR,&nbsp; &nbsp;FISCL_QTR_NBR,&nbsp;CLNDR_MNTH_NBR,&nbsp; FISCL_MNTH_NBR,&nbsp; &nbsp;CLNDR_DAY_OF_YR_NBR,&nbsp; &nbsp;FISCL_DAY_OF_YR_NBR12/30/2019 0:002019202041121364112/31/2019 0:00201920204112136521/1/2020 0:00202020201111131/2/2020 0:00202020201111241/3/2020 0:00202020201111351/4/2020 0:00202020201111461/5/2020 0:00202020201111571/6/2020 0:00202020201111681/7/2020 0:00202020201111791/8/2020 0:002020202011118101/9/2020 0:002020202011119111/10/2020 0:0020202020111110121/11/2020 0:0020202020111111131/12/2020 0:0020202020111112141/13/2020 0:0020202020111113151/14/2020 0:0020202020111114161/15/2020 0:0020202020111115171/16/2020 0:0020202020111116181/17/2020 0:0020202020111117191/18/2020 0:0020202020111118201/19/2020 0:0020202020111119211/20/2020 0:0020202020111120221/21/2020 0:0020202020111121231/22/2020 0:0020202020111122241/23/2020 0:0020202020111123251/24/2020 0:0020202020111124261/25/2020 0:0020202020111125271/26/2020 0:0020202020111126281/27/2020 0:0020202020111227291/28/2020 0:0020202020111228301/29/2020 0:0020202020111229311/30/2020 0:0020202020111230321/31/2020 0:0020202020111231332/1/2020 0:0020202020112232342/2/2020 0:0020202020112233352/3/2020 0:0020202020112234362/4/2020 0:0020202020112235372/5/2020 0:0020202020112236382/6/2020 0:0020202020112237392/7/2020 0:0020202020112238402/8/2020 0:0020202020112239412/9/2020 0:0020202020112240422/10/2020 0:0020202020112241432/11/2020 0:0020202020112242442/12/2020 0:0020202020112243452/13/2020 0:0020202020112244462/14/2020 0:0020202020112245472/15/2020 0:0020202020112246482/16/2020 0:0020202020112247492/17/2020 0:0020202020112248502/18/2020 0:0020202020112249512/19/2020 0:0020202020112250522/20/2020 0:0020202020112251532/21/2020 0:0020202020112252542/22/2020 0:0020202020112253552/23/2020 0:0020202020112254562/24/2020 0:0020202020112355572/25/2020 0:0020202020112356582/26/2020 0:0020202020112357592/27/2020 0:0020202020112358602/28/2020 0:0020202020112359612/29/2020 0:0020202020112360623/1/2020 0:002020202011336163

srk_powerbi · Answer

amitchandak&nbsp; &nbsp;can&nbsp; u help?

v-deddai1-msft · Answer

Hi&nbsp;srk_powerbi&nbsp;,
&nbsp;
Lack of many information. People here can't help you well. How many days contain in a fiscal month? How may days contain in a fiscal qtr? Is all the fiscal year starts at 12/30 or there is any logic with it?
&nbsp;
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.
&nbsp;
Best Regards,
Dedmon Dai
&nbsp;
&nbsp;

Forum Discussion

help..create a calcuated column in date table

2 Replies

Related content

Need help creating a measure

Help to create DAX Measure

Creating Calcuation Groups Help

Need help on creating calculated column

SUMX calcuation error

Calender_date,	CLNDR_YR_NBR,	FISCL_YR_NBR,	CLNDR_QTR_NBR,	FISCL_QTR_NBR,	CLNDR_MNTH_NBR,	FISCL_MNTH_NBR,	CLNDR_DAY_OF_YR_NBR,	FISCL_DAY_OF_YR_NBR
12/30/2019 0:00	2019	2020	4	1	12	1	364	1
12/31/2019 0:00	2019	2020	4	1	12	1	365	2
1/1/2020 0:00	2020	2020	1	1	1	1	1	3
1/2/2020 0:00	2020	2020	1	1	1	1	2	4
1/3/2020 0:00	2020	2020	1	1	1	1	3	5
1/4/2020 0:00	2020	2020	1	1	1	1	4	6
1/5/2020 0:00	2020	2020	1	1	1	1	5	7
1/6/2020 0:00	2020	2020	1	1	1	1	6	8
1/7/2020 0:00	2020	2020	1	1	1	1	7	9
1/8/2020 0:00	2020	2020	1	1	1	1	8	10
1/9/2020 0:00	2020	2020	1	1	1	1	9	11
1/10/2020 0:00	2020	2020	1	1	1	1	10	12
1/11/2020 0:00	2020	2020	1	1	1	1	11	13
1/12/2020 0:00	2020	2020	1	1	1	1	12	14
1/13/2020 0:00	2020	2020	1	1	1	1	13	15
1/14/2020 0:00	2020	2020	1	1	1	1	14	16
1/15/2020 0:00	2020	2020	1	1	1	1	15	17
1/16/2020 0:00	2020	2020	1	1	1	1	16	18
1/17/2020 0:00	2020	2020	1	1	1	1	17	19
1/18/2020 0:00	2020	2020	1	1	1	1	18	20
1/19/2020 0:00	2020	2020	1	1	1	1	19	21
1/20/2020 0:00	2020	2020	1	1	1	1	20	22
1/21/2020 0:00	2020	2020	1	1	1	1	21	23
1/22/2020 0:00	2020	2020	1	1	1	1	22	24
1/23/2020 0:00	2020	2020	1	1	1	1	23	25
1/24/2020 0:00	2020	2020	1	1	1	1	24	26
1/25/2020 0:00	2020	2020	1	1	1	1	25	27
1/26/2020 0:00	2020	2020	1	1	1	1	26	28
1/27/2020 0:00	2020	2020	1	1	1	2	27	29
1/28/2020 0:00	2020	2020	1	1	1	2	28	30
1/29/2020 0:00	2020	2020	1	1	1	2	29	31
1/30/2020 0:00	2020	2020	1	1	1	2	30	32
1/31/2020 0:00	2020	2020	1	1	1	2	31	33
2/1/2020 0:00	2020	2020	1	1	2	2	32	34
2/2/2020 0:00	2020	2020	1	1	2	2	33	35
2/3/2020 0:00	2020	2020	1	1	2	2	34	36
2/4/2020 0:00	2020	2020	1	1	2	2	35	37
2/5/2020 0:00	2020	2020	1	1	2	2	36	38
2/6/2020 0:00	2020	2020	1	1	2	2	37	39
2/7/2020 0:00	2020	2020	1	1	2	2	38	40
2/8/2020 0:00	2020	2020	1	1	2	2	39	41
2/9/2020 0:00	2020	2020	1	1	2	2	40	42
2/10/2020 0:00	2020	2020	1	1	2	2	41	43
2/11/2020 0:00	2020	2020	1	1	2	2	42	44
2/12/2020 0:00	2020	2020	1	1	2	2	43	45
2/13/2020 0:00	2020	2020	1	1	2	2	44	46
2/14/2020 0:00	2020	2020	1	1	2	2	45	47
2/15/2020 0:00	2020	2020	1	1	2	2	46	48
2/16/2020 0:00	2020	2020	1	1	2	2	47	49
2/17/2020 0:00	2020	2020	1	1	2	2	48	50
2/18/2020 0:00	2020	2020	1	1	2	2	49	51
2/19/2020 0:00	2020	2020	1	1	2	2	50	52
2/20/2020 0:00	2020	2020	1	1	2	2	51	53
2/21/2020 0:00	2020	2020	1	1	2	2	52	54
2/22/2020 0:00	2020	2020	1	1	2	2	53	55
2/23/2020 0:00	2020	2020	1	1	2	2	54	56
2/24/2020 0:00	2020	2020	1	1	2	3	55	57
2/25/2020 0:00	2020	2020	1	1	2	3	56	58
2/26/2020 0:00	2020	2020	1	1	2	3	57	59
2/27/2020 0:00	2020	2020	1	1	2	3	58	60
2/28/2020 0:00	2020	2020	1	1	2	3	59	61
2/29/2020 0:00	2020	2020	1	1	2	3	60	62
3/1/2020 0:00	2020	2020	1	1	3	3	61	63