Forum Discussion
paulsnet1986
Helper I
Helper INeed Help With Time-Series Measures: One and Two Months Prior Sales Based on Selected Value
Hi, I am really struggling with this one: I need to create a margin report by product in that, when a given month is selected, the measures will give me the sum of the margins for each product for t...
Hi paulsnet1986
You can use these measures :
1. current month margin = sum('Table'[Margin])2.One Month Prior = CALCULATE([current month margin],DATEADD('Table'[Invoice],-1,MONTH))+03. Two Month Prior = CALCULATE([current month margin],DATEADD('Table'[Invoice],-2,MONTH))+0If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi 1. Try to check your steps near the file I linked in the first reply.
2. If it still not working:
- Create a date table.- Create a relationship between it and your invoices table
- Mark this table as a date table
- Use this table for the formulas modify them to :
current month margin = sum('Table'[Margin])One Month Prior = CALCULATE([current month margin],DATEADD('Dates_table'[Date],-1,MONTH))+0Two Month Prior = CALCULATE([current month margin],DATEADD('Dates_table'[Date],-2,MONTH))+0
Ritaf1983
Super User
Super UserHi 1. Try to check your steps near the file I linked in the first reply.
2. If it still not working:
- Create a date table.
- Create a relationship between it and your invoices table
- Mark this table as a date table
- Use this table for the formulas modify them to :
current month margin = sum('Table'[Margin])
One Month Prior = CALCULATE([current month margin],DATEADD('Dates_table'[Date],-1,MONTH))+0
Two Month Prior = CALCULATE([current month margin],DATEADD('Dates_table'[Date],-2,MONTH))+0
paulsnet1986Helper I
Helper IThat solved it! Ritaf1983 THANK YOU SO MUCH!
- Ritaf1983
Glad to help 🙂