I have a table called Hyp with below data
Quarter Target Date
Q1 50 Dec 31,2023
Q2 65 Mar 30,2024
Q3 90 June 30, 2024
Q4 120 Sep 30, 2024
Basically the targets are incremental counts and trying to derive like below:
Quarter Target
Q1 50
Q2 15
Q3 25
Q4 30
Q2 target will be Q2 Target – Q1 target
Wrote a DAX below but it is returning blank:
prevQtr = CALCULATE(SUM(‘Hyp'[taregt]), PREVIOUSQUARTER(‘Hyp'[Date]))
New contributor
Sam Peter is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.