Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello PBI people!
First of all, I don't have a pbix, it's just a theoretical question.
I have a field date with the automatic hierarchy (week, month, year) but I need to change it: for example I want to consider that the weeks expires together with the month, so for example I might have a week made by 2 days and the other week made by 5 days.
Or I want to calculate the weeks starting from Wednesday.
Is it possible to do that? If yes, how?
Thanks in advance!
Solved! Go to Solution.
Hi! Check out this article I wrote that discusses custom date tables and one that I love from SQLBI which can be tweaked to meet your specific needs: http://powerbiwithme.com/2023/08/01/the-custom-date-table-edition/
Proud to be a Super User! | |
Hi! Check out this article I wrote that discusses custom date tables and one that I love from SQLBI which can be tweaked to meet your specific needs: http://powerbiwithme.com/2023/08/01/the-custom-date-table-edition/
Proud to be a Super User! | |
Hi Audrey
If I understand correctly, to create that custom date table, the add-in is mandatory?
Hi! There's no add-in, you just need the DAX code which you can download from SQLBI (the link is in my blog post) and then you do 'New Table' in Power BI.
Proud to be a Super User! | |