Forum Discussion

dkay84_PowerBI's avatar
dkay84_PowerBI
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago
Solved

DAX help

I am trying to calculate sales YTD (using week number) vs. sales Last Year YTD.  I can't use SAMEPERIODLASTYEAR because I have a custom FY calendar.  My data will only ever have the current FY (YTD) ...
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    dkay84_PowerBI

     

    hi, With this modifcation should be work.

     

    Last YTD Sales =
VAR LY = [Last Year]
VAR LW = [Latest Week YTD]
RETURN
    CALCULATE (
        SUM ( Table1[Sales] ),
        FILTER ( ALL ( Table1 ), Table1[FY] = LY && Table1[Week Number] <= LW )
    )
v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi dkay84_PowerBI,

You should create the measure using the formula dkay84_PowerBI posted. Please feel free to ask if you have other issue.

Best Regards,
Angelia