Need to increment the date value in rows based on the coloumn value and duplicate the row values.

[zeusturbo]

Hi,
I wanted to increment the date value based on a  particular column value. And also need to duplicate the entire rows by the values based on that column. I have an example below.

If you see the above image, the rows are duplicated based on values in the "Nights" columns and the "Date" column is incremented based on the "Nights" columns.

Please help me with it.

Thanks in advance..

[daxer-almighty]

It's dead easy if you use Power Query to do this. And in truth, it should be done via Power Query, not in DAX. DAX is not suitable for this kind of data manipulation. Power Query is.

[Greg_Deckler]

@zeusturbo - To follow-up on this, I did something similar to this in this Quick Measure: 

Blowout! - Microsoft Power BI Community

[zeusturbo]

@Greg_Deckler   

thanks for the response. here is the sample data. 

Name, Room no., RT., Adlt., Total_Person, Date, Nights, Price, Rate code, Stat., Group
Voegele, 116, D2D, 2/0/0/0/0, 2, 01/01/2016 ,7, 496, GR02, CO, X1
Petersen, 103, D2D, 2/0/0/0/0, 2, 05/01/2016, 2, 330, ARH Import, CO, X2
Michelin, 205, D2D, 2/0/0/0/0, 3, 07/01/2016, 5, 319, ARH04 ,CO ,X3

[Greg_Deckler]

@zeusturbo Inventing rows is tricky in Power BI. You will need to use GENERATE or GENERATESERIES in DAX to invent these rows. You may actually need to use both in conjunction with one another, essentially:

GENERATE(

  'Table',

  GENERATESERIES(...)

)

Can you post input sample data as text so that I can experiment with the right solution?