Forum Discussion
pymisdept
7 years agoNew Member
Compare SamePeriod Sales
Hello,
I want to compare the sales Month vs LY Month. It is fine with the non-current month, but for current month, it will only show the result upto same date last year. Is there anyway to show the last year full month sales ?
I tried below, but also cant get the result.
LY Sales = CALCULATE(SUM(Sales[SalesRetailValue]),SAMEPERIODLASTYEAR(ENDOFMONTH(DimDate[FullDate]))) LY Sales = CALCULATE(SUM(Sales[SalesRetailValue]),SAMEPERIODLASTYEAR(DimDate[FullDate]))
Would like to get help from the expert.
Thank you in advance!
- Hi
Use parallelperiod dax function
https://msdn.microsoft.com/en-us/query-bi/dax/parallelperiod-function-dax
1 Reply
- Zubair_MuhammadCommunity ChampionHi
Use parallelperiod dax function
https://msdn.microsoft.com/en-us/query-bi/dax/parallelperiod-function-dax