Forum Discussion
Solved
create new table from begin date, end date, transactionuid
I'm not sure if this is in the correct Location... I have a table of reservation data with a column for "reservation #", "begin date", "end date", and "revenue" (plus some other misc. columns). ...
- I have not taken online courses however, I have watched quite a few videos on https://www.sqlbi.com/, read a lot on https://www.daxpatterns.com/ and of course https://msdn.microsoft.com/en-us/query-bi/dax/dax-function-reference
- I've used a technique in Power Query the Query Editor in Power BI which may help you get started.
Using List.Transform:
List.Transform({Number.From([BeginDate])..Number.From([EndDate])},each Date.From(_))Starting from a simple table in the Power Query Editor:
Add Column:
Expand the Custom Column:
Gets you:
Remove [BeginDate] & [EndDate] will get you to what I believe is your desired outcome (to start in you journey):
40940 = 2/1/2012 correct?
Write as:
List.Transform({Number.From([BeginDate])..Number.From([EndDate])},each Date.Month(Date.From(_)))
Thank you very much! That one worked!