Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
User | Count |
---|---|
86 | |
82 | |
68 | |
66 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |