NIce job. I liked your use of the sequence capabilities of Power Query. Also, you had the best explanation I have seen on why you need a date table in Power BI. Thanks!
This is great. Thank you so much! I'd love if you could make a video on making a fiscal yr DYNAMIC date table that goes back full X number of years + YTD (ex. full 4 fiscal yrs + YTD where fiscal year ends Sep 30th).
First: Don't enter . If you write datestartof then editor helps and you can choose Date.StartOfYear and the duplicated DateDate on start dioesn't appear. Second: Correct date table includes full years, then time intelligence formulas work. In demo case it must be 1/1/2021 until 13/31/2024. And it would be nice if it were also said that after importing the table, the table should be marked as a date table and the date column should not be specified. Also needed for correct time intelligence.
Hi, thank you for this video which certainly has interesting content, but the formulas you apply are blurry and for me they are too small due to my vision problem, I can't see them well. It would have been better if she had zoomed in on them. Thank you anyway.
I appreciate this method of creating a date table. I never found a convert to table on my Ribbon. I went to properties on the list of apps and manually entered the convert to table and then after that everything was great. Was I missing something?
I have the exact same problem. The DateTime tools do not appear for me either. They do in Power Query for Excel but not in PBI. Funny thing is on my home computer the tools show up for PBI but not on my work machine. I also could not find a setting for this. If anyone knows where this setting is that would be great. My work around was to wrap the = {DateTime.LocalNow()} in curly brackets to create a list, then right click on the list header and create the table. A list should also have at set List Tools but they don't show up either.
Hi, thanks for your video. It will help me a lot. But Im applied a similar approach, and Im having problems to make Power BI recognize my column as Date Type... I mean, that small icon on Power BI, that indicate the column is a "Date/Time or Date" format, is not appearing. And I'm shure to enter the Power Query steps, and checked every "Type Change", but once I Close and Apply the modifications, all my date columns remains the same (without that calendar icon). Do anyone could help me with that?
Awesome explanation 🎉🎉🎉 I have a question is there a way to dynamically determine the first or oldest date in your model. Assuming you have multiple tables with their respective date/time columns. Thx 🙏
NIce job. I liked your use of the sequence capabilities of Power Query. Also, you had the best explanation I have seen on why you need a date table in Power BI. Thanks!
Great video, you could show a sample of usage to make it more clear!
Thank you do much for showing dynamic date filters.
This is great. Thank you so much! I'd love if you could make a video on making a fiscal yr DYNAMIC date table that goes back full X number of years + YTD (ex. full 4 fiscal yrs + YTD where fiscal year ends Sep 30th).
First: Don't enter . If you write datestartof then editor helps and you can choose Date.StartOfYear and the duplicated DateDate on start dioesn't appear.
Second: Correct date table includes full years, then time intelligence formulas work. In demo case it must be 1/1/2021 until 13/31/2024.
And it would be nice if it were also said that after importing the table, the table should be marked as a date table and the date column should not be specified. Also needed for correct time intelligence.
Hi, thank you for this video which certainly has interesting content, but the formulas you apply are blurry and for me they are too small due to my vision problem, I can't see them well. It would have been better if she had zoomed in on them. Thank you anyway.
Excellent Tutorial.............
I was looking for the same, Thanks a lot..........!!!
I appreciate this method of creating a date table. I never found a convert to table on my Ribbon. I went to properties on the list of apps and manually entered the convert to table and then after that everything was great. Was I missing something?
I have the exact same problem. The DateTime tools do not appear for me either. They do in Power Query for Excel but not in PBI. Funny thing is on my home computer the tools show up for PBI but not on my work machine. I also could not find a setting for this. If anyone knows where this setting is that would be great. My work around was to wrap the = {DateTime.LocalNow()} in curly brackets to create a list, then right click on the list header and create the table. A list should also have at set List Tools but they don't show up either.
A different approach. I liked it. thanks.
Great
Thank you for that tutorial, but at the end date col, we have 6 as hard coded, and I need to be a dynamic. Could you support.
What do I do with the created list? After going through such a lengthy process. Could have done it in a jiffy in Excel with Sequence!
Hi, thanks for your video. It will help me a lot. But Im applied a similar approach, and Im having problems to make Power BI recognize my column as Date Type...
I mean, that small icon on Power BI, that indicate the column is a "Date/Time or Date" format, is not appearing. And I'm shure to enter the Power Query steps, and checked every "Type Change", but once I Close and Apply the modifications, all my date columns remains the same (without that calendar icon).
Do anyone could help me with that?
Awesome explanation 🎉🎉🎉
I have a question is there a way to dynamically determine the first or oldest date in your model. Assuming you have multiple tables with their respective date/time columns.
Thx 🙏
This is my question too
Interesting