March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
09-28-2016 09:02 AM
For this data story, my first goal was to be able to create any Date Period that was required for the data. As with the example we have creaated a few simple Periods "CY-LY" (Calendar Year - Last Year), "CY-YTD" (Calendar Year - Year to Date). And in doing so, it gives the user the ability quickly slice their data by the defined period.
Second to this I also created a solution in which the Month Names would dynamically change to either the Fiscal Months (If a Fiscal Period was selected) or Calendar Months (If a Caleandar Period was selected).
So in the report if you click on "CY-YTD", you will see that the dates follow "Jan-May"
Whilst if you click on "FY-LY", you will see that the dates follow the Fiscal Periods "Nov - October"
The final part of the data story is that using the Periods, it makes it very easy to create Calculated Measures based on your custom periods. And his is a lot easier and quicker when your custom periods do not have built in DAX functions.
In doing so that this does is it enables the user to have the ability to quickly and easily slice their data based on custom periods.
I have also published a blog post in terms of how I achieved this.
Create Dynamic Periods for Fiscal or Calendar Dates in Power BI
eyJrIjoiZGNjNGUzM2ItZWVhOS00ZWRlLWFlZmEtZjljMDZlMmNmMTY0IiwidCI6ImQ3MGI0ZDU1LWE1OTItNDVmMi05OWYzLTI5OWFlNWVlN2FkZSJ9
Hi @amirsheva
If you click on the blog post, and then go to the end you will see the option to download the PBIX
Do you offer Power BI classes?
Very good dashboard and financial calender is what a lot of companies use.
What did you use to publish this dashboard into a webpage.
I am new to this environment.
regards
willy
let TodaysDate = Date.From(DateTimeZone.FixedUtcNow()), YearText = Number.ToText(2000), FiscalStartMonth = Date.Month(Date.FromText(“”&YearText&”-“&#”Fiscal Start Month”&“”)), FiscalStartMonthDay = Date.Day(Date.StartOfMonth(Date.FromText(“”&YearText&”-“&#”Fiscal Start Month”&“”))), FiscalEndMonth = Date.Month(Date.FromText(“”&YearText&”-“&#”Fiscal End Month”&“”)), FiscalEndMonthDay = Date.Day(Date.EndOfMonth(Date.FromText(“”&YearText&”-“&#”Fiscal End Month”&“”))),
where did he edit this, =_= I don't know where I couldn't replicate the example =_=
Very nice report. Thanks for the blog post too. May I ask what's the KPI like visual u use on page 3? Where can I find it?
Hi there
Thanks for the kind words. And the visual on page 3 was done by a 3rd party developer.
You can contact him on contact@dax365.com his name is Nick Savenko
thank you for the information.
Nice Dashboard, really like the feature which allows to select the unit of measure and the different date periods. By the way, on Page 4 there is a breakdown tree. Is it possible to share the visualization, I was searched for this since Performance Point.