I have a fact table like the one below:
Date Revenue Quantity
31/01/2021 1000 500
28/02/2021 2000 500
31/12/2021 3000 100
31/01/2022 4000 200
28/02/2022 5000 100
The fact table is connected to a data table: my goal is calculate the ASP (Revenue / Quantity) and set the ASP from the 31/12/2021 (30.00) for every row in the 2022 having a result like the following
Can someone help me to figure out a simple measure to be used with the same logic in a report?
Thank you in advance,
Go to Solution.
I solved my issue with the following formula
View solution in original post
ASP_21 = calculate ( Revenue / Quantity, 'Table'[DATE] =31/12/2021) return
IF ('Table'[DATE] <=31/12/2021,Revenue / Quantity, ASP_21)
Vote for your favorite t-shirt design now through March 28.
Find out more about the March 2023 update.
Find out more about the online and in person events happening in March!