Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
hi ,
i have date table like below. what 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.
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 |
Hi @srk_powerbi ,
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?
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai