Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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..
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.
@zeusturbo - To follow-up on this, I did something similar to this in this Quick Measure:
Blowout! - Microsoft Power BI Community
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
@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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
22 | |
20 | |
15 | |
13 |
User | Count |
---|---|
49 | |
41 | |
39 | |
19 | |
19 |