Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

ytd sales help

Hi experts, need to calculate total sales for the current year  and last year based on the fiscal year (apr - mar). I have year filter in the report. I need to calculate based on the selected year. P...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    4 years ago

    Hi Anonymous ,

     

    Try to create measures like below:

    Sales FYTD = 
TOTALYTD( [Total Sales],
    Dates[Date], ALL( Dates[Date] ), "30-6" 
)
    Sales PY FYTD = 
CALCULATE( [Sales FYTD],
    SAMEPERIODLASTYEAR( Dates[Date] )
   
)

     


    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

amitchandak In my report, year filter only available. Abobe formula will work for date range filter, right?

V-lianl-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi Anonymous ,

 

Try to create measures like below:

Sales FYTD = 
TOTALYTD( [Total Sales],
    Dates[Date], ALL( Dates[Date] ), "30-6" 
)
Sales PY FYTD = 
CALCULATE( [Sales FYTD],
    SAMEPERIODLASTYEAR( Dates[Date] )
   
)

 


Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.