Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
I have sales table, product table and calendar table
I have slicers for FY, Month and Product
I need to get last year sales value for the current month selected. This is my DAX expression
Solved! Go to Solution.
Hi
Thanks for the reply. I am getting the same error "DATEADD can be used only when contiguous dates exist..."
I have used PARALLELPERIOD(BI vwSETSales[Transaction Date], -12, MONTH) and it worked
How about change your measure using dax below?
Booked Sales(SET) Last Year = CALCULATE ( SUM ( 'BI vwSETSales'[Actual Revenue] ), FILTER ( ALL ( 'BI vwSETSales' ), 'BI vwSETSales'[Source] = "WON_OPPS" && 'BI vwSETSales'[Product Group] IN VALUES ( 'BI vwProductGroup'[Target Group] ) ), DATEADD ( 'BI vwSETSales'[Transaction Date], -1, YEAR ) )
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi
Thanks for the reply. I am getting the same error "DATEADD can be used only when contiguous dates exist..."
I have used PARALLELPERIOD(BI vwSETSales[Transaction Date], -12, MONTH) and it worked
Thank you very much, I've been trying for a long time to solve this error problem and with your solution of using 'PARALLELPERIOD' it was solved.
Change your transaction date to your date from calendar table
Hi,
Thanks for the reply. I have tried but it is calculating SUM(vwSETSales[Actual Revenue]) from entire resutset
No filters applied.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |