Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi experts
How would you integrate the same period last year function into the following DAX..
CALCULATE( [Net Sales BM PY] , FILTER( ALL(Profitability[DIM_POSTING_DATE_SK]), CONTAINS( VALUES('DateFilter'[DIM_DATE_SK]),'DateFilter'[DIM_DATE_SK], Profitability[DIM_POSTING_DATE_SK] ) ) ))
Solved! Go to Solution.
hi,@Route11
You can use SAMEPERIODLASTYEAR Function to add a calculate measure like this:
Measure 2 = CALCULATE([Measure],SAMEPERIODLASTYEAR(Table2[Date]))
Result:
Best Regards,
Lin
hi,@Route11
You can use SAMEPERIODLASTYEAR Function to add a calculate measure like this:
Measure 2 = CALCULATE([Measure],SAMEPERIODLASTYEAR(Table2[Date]))
Result:
Best Regards,
Lin
Hi @Anonymous,
This information is very limited to give you an answer please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490 (courtesy of @Greg_Deckler).
Can you provide addtional information on what is the expected result and calculations your need to make.
Regards.
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsMFliex - thi si what i came up with
CALCULATE( CALCULATE( [Net Sales BM] , FILTER( ALL(Profitability[DIM_POSTING_DATE_SK]), CONTAINS( VALUES('DateFilter'[DIM_DATE_SK]),'DateFilter'[DIM_DATE_SK], Profitability[DIM_POSTING_DATE_SK] ) ) ) , SAMEPERIODLASTYEAR(DateFilter[Full Date]) )
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |