Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi experts,
Need to calculate fInancial year sales (starting from april) based on the end date or year-month selected by the user.
Please help
Solved! Go to Solution.
Hi,
You may download my PBI file from here.
Hope this helps.
Hi,
Share the link from where i can download your PBI file.
@Ashish_Mathur Please refer below pbix file
https://drive.google.com/file/d/1flF3jg4ZFqZM_wAjYhQVcoB3OQH0p0jf/view?usp=sharing
Hi,
You may download my PBI file from here.
Hope this helps.
@Anonymous
Not enough information to understand your requirements, If you need the past 12 months sales then this measure should work for you.
FY Sales =
CALCULATE(
[Total Sales],
DATESINPERIOD( 'dates'[Date] , -1 , YEAR )
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hi, Need to calculate fInancial year sales (starting from april) based on the end date or year-month selected by the user.
Hi, @Anonymous
You can check this article https://allure-analytics.com/index.php/2022/05/14/standard-calendar-date-table-in-power-bi/
In your case you can use the code in ULTIMATE DYNAMIC DAX CALENDAR + FISCAL PERIODS
and change _startOfFiscalYear to 4 and use it as a slicer. You need to connect it to your sales table by Date.
Also, if you need to calculate Fiscal YTD just check this:
https://allure-analytics.com/index.php/2022/05/24/time-intelligence-in-power-bi/
or simply:
FiscalYTD = CALCULATE([Sales], DATESYTD('Date'[Date], "03/31") --where 03/31 is end date and fiscal year start on 1st April
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
139 | |
100 | |
95 | |
85 | |
63 |