Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
My fiscal Year data is wrong for FY 20 & FY 21... why is this happening but it's correct for FY 22,23,& 24??
This is my Volume LY Formula
@lennyt99 , seem like related to leap year, Try like
Volume LY =
CALCULATE(
SUM('Opportunity Tracker 2.0'[Annual Volume LBS]),
SAMEPERIODLASTYEAR('Fiscal Year Conversion'[Calendar Date]))
Unfortunatly still the same for the period of FY2020. My fiscal calendar start and end date vary.. for exaple one year it starts 9/30, and another it starts 10/2... so perhaps -1 year that's why it's off? How do I do it by fiscal year?
I've tried that also, however yields the same result. What if a filter is used only for the fiscal year?
@lennyt99 ,Only for year level
Rank on FY start Date or Fy year number (sortable)
Year Rank = RANKX(all('Date'),'Date'[FY Year Start date],,ASC,Dense)
Measure
This Year = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Year Rank]=max('Date'[Year Rank])))
Last Year = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Year Rank]=max('Date'[Year Rank])-1))
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
21 | |
17 | |
16 | |
11 | |
7 |
User | Count |
---|---|
26 | |
25 | |
12 | |
12 | |
12 |