User Profile
snaik1
New Member
Joined 1 year ago
User Widgets
Contributions
Re: If User can change default FISCAL YEAR starting month & end month
I have explored all the threads related to Fiscal Year/Qtr and Period in PowerBI. The majority of them suggest using the Date calendar. But this calendar does not work, if we have multiple dates in a data source e.g., "Invoice date", "Order date" and "Ship date" in the data table, 3 different users of the dashboard would like to analyse based on a different date and they all want it in Fiscal format. They cannot do it. Either they have to create 4 different columns and build a hierarchy for each field or have multiple Date tables. Not all business users can build difficult DAX formulas. They complain that they are not IT programmers. End (PowerBI service) users cannot use "USERELATIONSHIP". End users cannot enter or build the formula to select the particular date. It would be a great help if you have FiscalYearoffset like Spotfire. If we set offset as -3 (Document property) for example, the application understands that October is the 1st period of a new fiscal year. Something like this - date property, which we can easily select. Thank you.283Views0likes0Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.