- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Show Sales detail for the previous fiscal year
Good day.
I am looking for asistance with a DAX measure to show the Sales detail for the prior complete Fiscal year.
My measure for the Previous fiscal YTD is working fine:
/*Previous Fiscal YTD*/
Sales (PYTD) =
VAR DataMaxDate = TODAY()
RETURN
CALCULATE (
CALCULATE([Total Sales], DATESYTD('Calendar'[Date].[Date],"28/2")),
SAMEPERIODLASTYEAR (
INTERSECT (
VALUES ( 'Calendar'[Date].[Date] ),
DATESBETWEEN ( 'Calendar'[Date].[Date], BLANK (), DataMaxDate )
)
)
, ALL( 'Calendar'[FiscalYear])
)
However the measure for showing the detail for the whole fiscal period, I am stuck with. Currently I have:
/*Full Previous Fiscal Year*/
Sales (PY) =
CALCULATE(
[Total Sales],filter('Calendar', year('Calendar'[Date]) = Year(Today())-1)
)
The results from this measure shows me the sales for the whole calendar year. It starts on 2022/01/01 instead of 2022/03/01.
It ends at 2022/12/30 where it should end on 2023/02/28.
In this snippet it shows where the Sales (PY) should start:
This snippet shows where it ends on the last day of the 2022, instead of ending on 2023-02-28:
What I need to achieve is a object like this. It compares the full year v the YTD.
Thank you very much in advance.
John
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@IA_John Bit difficult to be specific with this without sample data. You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000
Also, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...
Also, these videos may help as well:
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
Subject | Author | Posted | |
---|---|---|---|
08-06-2023 01:43 AM | |||
07-11-2023 07:13 AM | |||
Anonymous
| 09-08-2023 01:10 AM | ||
06-26-2023 09:15 PM | |||
07-25-2024 04:59 AM |
User | Count |
---|---|
21 | |
17 | |
16 | |
7 | |
5 |
User | Count |
---|---|
29 | |
28 | |
20 | |
13 | |
12 |