Forum Discussion
Quarter-on-Quarter Data using Power BI Dataset
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