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
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
@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:
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
22 | |
19 | |
16 | |
9 | |
5 |
User | Count |
---|---|
37 | |
29 | |
16 | |
14 | |
12 |