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.
I believe that my doubt is simple, I have a query with product codes and i want that for each of these records have the date (the 365 days of the year).
Solved! Go to Solution.
Tough to say exactly because I'm not sure what you want. But, if you had that table and you create a Calendar table like:
Calendar = CALENDAR(DATE(2018,1,1),DATE(2018,12,31))
Then you could do this:
Table = GENERATE(productstable,Calendar)
It's a DAX solution, not Power Query.
In the query editor you would add a column with this formula:
List.Dates(#date(2018,01,01),365,#duration(1,0,0,0))
Just expand the column then.
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Tough to say exactly because I'm not sure what you want. But, if you had that table and you create a Calendar table like:
Calendar = CALENDAR(DATE(2018,1,1),DATE(2018,12,31))
Then you could do this:
Table = GENERATE(productstable,Calendar)
It's a DAX solution, not Power Query.
THANKS !!!
That's exactly what I needed.
Just one more question!
Eu consigo fazer isso no editor de consultas?
Maybe, but that is a question for @ImkeF
Thanks!
In the query editor you would add a column with this formula:
List.Dates(#date(2018,01,01),365,#duration(1,0,0,0))
Just expand the column then.
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Perfect!
Thanks
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 |
---|---|
110 | |
97 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |