help me to create months based on my date in dashboard?

[durgabhavani]

Hi All,

Help me to create months-year based on my date in dashboard. My date is like below.

Date

14032018

Expected Output:

Jan-18

Feb-18

Mar-18

Apr-18

May-18

Jun-18

Jul-18

Aug-18

Sep-18

Oct-18

Nov-18

Dec-18

Thanks,

Durga

[sunny_talwar]

How can a single date (14032018)... be transformed into multiple dates?

[durgabhavani]

I want to just derive month and year (MMM-YY) for current year using the variable (date). let me know if it is not possible.

[sunny_talwar · Accepted solution]

May be this

Table:

LOAD Date(AddMonths(YearStart(Today()), IterNo() - 1), 'MMM-YY') as MonthYear

AutoGenerate 1

While IterNo() <= 12;

[durgabhavani]

Perfect Sunny. Its working. thanks for reply.