Forum Discussion
Solved
[HELP] Breaking Inicial Date and Final Date into various date lines in Table Model
Hello Everyone, first post here in the community. I hope to be as clear as possible. I work in the marketing departament and I created a Google Sheets to put all of our products campaign. So each...
Hi danilindoso,
Create a new custom column and try this:
List.Dates([Initial Date],[Final Date]-[Initial Date]+1,#duration(0,0,0,1)).
expand the column.
Please let me know if this resolved the question.Appreciate a thumbs if this is helpful.
Here is the PBI File.
We have 4 tables:
- Database orders (that creates line for each purchase)
- Database Products_Sold (To conect with table orders and see what are the products sold)
- Store (To see the name of the stores that sold the products)
- Products_Campaign (This is the google sheets database that I put every single product campaign)
https://drive.google.com/file/d/1kJzJo_QwokYNdEuVx6BVZazpZwCM5v_4/view?usp=share_link