Forum Discussion
Solved
Transpose table with every period in between dates
So i have a table with rental objects. Each object has an ID. each row in the table shows new index regulations. So for the chosen ID i got 2 regulations. In order to compare vs accounting i need...
Hi stiani ,
if you add a new column calling this custom function: Date.DatesBetween to retrieve dates between 2 dates in Power BI and Power Query – The BIccountant
you should achieve your goal without transposing. When you choose "Month" in the 3rd parameter, you can simply expand the result and will get one row per month.
ImkeF
Community Champion
Community ChampionHi stiani ,
if you add a new column calling this custom function: Date.DatesBetween to retrieve dates between 2 dates in Power BI and Power Query – The BIccountant
you should achieve your goal without transposing. When you choose "Month" in the 3rd parameter, you can simply expand the result and will get one row per month.