Forum Discussion

AllanXu's avatar
AllanXu
Helper II
10 years ago

DAX Forum?

Greetings,   Is there any active DAX form, so I can post my DAX related questions there?   Thank you,  
Need Help
Patrick-G's avatar
Patrick-G
New Member
5 years ago

 Hi,

 

I am trying to create a rail period date table using DAX to be dynamic and have no idea where to start; any help will be much appreciated. Cheers!

 

Example There are 13 periods in total.

DatePeriodsFiscal YearStart DateEnd DateDuration
01 April 2020P12020-2101 April 202002 May 202032
02 April 2020P12020-2101 April 202002 May 202032
03 April 2020P12020-2101 April 202002 May 202032
04 April 2020P12020-2101 April 202002 May 202032
05 April 2020P12020-2101 April 202002 May 202032
06 April 2020P12020-2101 April 202002 May 202032
07 April 2020P12020-2101 April 202002 May 202032
08 April 2020P12020-2101 April 202002 May 202032
09 April 2020P12020-2101 April 202002 May 202032
10 April 2020P12020-2101 April 202002 May 202032
11 April 2020P12020-2101 April 202002 May 202032
12 April 2020P12020-2101 April 202002 May 202032
13 April 2020P12020-2101 April 202002 May 202032
14 April 2020P12020-2101 April 202002 May 202032
15 April 2020P12020-2101 April 202002 May 202032
16 April 2020P12020-2101 April 202002 May 202032
17 April 2020P12020-2101 April 202002 May 202032
18 April 2020P12020-2101 April 202002 May 202032
19 April 2020P12020-2101 April 202002 May 202032
20 April 2020P12020-2101 April 202002 May 202032
21 April 2020P12020-2101 April 202002 May 202032
22 April 2020P12020-2101 April 202002 May 202032
23 April 2020P12020-2101 April 202002 May 202032
24 April 2020P12020-2101 April 202002 May 202032
25 April 2020P12020-2101 April 202002 May 202032
26 April 2020P12020-2101 April 202002 May 202032
27 April 2020P12020-2101 April 202002 May 202032
28 April 2020P12020-2101 April 202002 May 202032
29 April 2020P12020-2101 April 202002 May 202032
30 April 2020P12020-2101 April 202002 May 202032
01 May 2020P12020-2101 April 202002 May 202032
02 May 2020P12020-2101 April 202002 May 202032