Find my approach as reference below and stored in attached workbook version 9.3
a. CQ-4: if datediff('quarter',[Date], today())=4 then [Sales] END
b. CQ: if datediff('quarter',[Date], today())=0 then [Sales] END
c. Delta %: sum([CQ])/sum([CQ-4])
QOQ.twbx 20.3 KB
Thank you for your reply. When I did that it displays the metric name in the label but it should displays the date(quarters) dynamically. I think we need to filter it in such a way to display as mentioned above. Please guide me.