Quick Sight Formula to Split months based on Start Date and End Date

Hi Team,

Kindly help to give suggestions as I have a column start date, End Date, Monthly Rate which is coming from the database table from which i want to derive the columns Jan25,Feb25,Mar25,Apr25. These columns should come dynamically based on start date and enddate along with year mentioned.

Hi @Meena1

I see a problem with your requirement. Creating it dynamically is one thing, but each field requires an identifier and if that is dynamic any downstream usage is not possible.

What exactly are you trying to achieve with these dynamic columns? You can given one row as example from your table, what if each row has different start and end dates with different ranges?

Regards,
Giri

Regards,
Giri