topic Re: Need to increment the date value in rows based on the coloumn value and duplicate the row values. in DAX Commands and Tips

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

zeusturbo — Wed, 16 Dec 2020 17:10:39 GMT

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..

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

Greg_Deckler — Wed, 16 Dec 2020 17:41:18 GMT

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?

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

Greg_Deckler — Wed, 16 Dec 2020 19:27:10 GMT

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

Blowout! - Microsoft Power BI Community

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

zeusturbo — Wed, 16 Dec 2020 19:54:18 GMT

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

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

daxer-almighty — Thu, 17 Dec 2020 20:09:55 GMT

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.