Power BI
Needs VotesAdd Fiscal Month and Fiscal Year to the Query Editor "Add Column " Date Button
Wyn Hopkins on 09 Apr 2017 09:12:56
The Query Editor allows you to easily create Year, Month, Month Name etc, but many people need Fiscal Month No and Fiscal year
- Comments (4)
RE: Add Fiscal Month and Fiscal Year to the Query Editor "Add Column " Date Button
This should be merged with an older idea on the same topic.https://ideas.powerbi.com/ideas/idea/?ideaid=c58ddf2d-959f-4618-a617-4937c730c224
RE: Add Fiscal Month and Fiscal Year to the Query Editor "Add Column " Date Button
Agreed, Tableau is so far ahead of Power BI on dates it's sad.
RE: Add Fiscal Month and Fiscal Year to the Query Editor "Add Column " Date Button
Tableau has had a fiscal calendar option for years. Makes it soooooo easy to work in fiscal dates. Tableau delivers a fiscal date solution out of the box. So, you don't spend hours in the difficult gymnastics of DAX or Power Query solutions trying to get a fiscal date view. I love Power BI, but hate the work and limitations of I face due to the lack of an easy built in fiscal calendar solution.
RE: Add Fiscal Month and Fiscal Year to the Query Editor "Add Column " Date Button
Tableau does a great job with fiscal dates. Power BI needs this. It takes far too much time to build mockup fiscal calendars, and even when you build them, they don't work with great Power BI's Analytics Pane tools like Forecasting or Anomaly detection.