Quarter-on-Quarter Data using Power BI Dataset

[Anonymous]

Hi,

I am trying to show the value of a KPI whereby my indicator changes to the sum for the last quarter (i.e. when it turns July, Q2 figures are shown). My DAX input is:

Value of Deals to Contract Conv Rate QoQ = CALCULATE(sum(Query1[Amount]), DATEADD(PREVIOUSQUARTER(_Date)))

I believe the problem is the '_Date', as I have created this as a new measure using: _Date = TODAY(), but it does not recognise it when i type in _Date into the PREVIOUSQUARTER brackets. Help! Thanks

[Anonymous]

https://dax.guide/previousquarter