Power BI DAX: ISFILTERED, ERROR, CALCULATE, SUM, DATEADD, DIVIDE
Sales QoQ% =
IF (
ISFILTERED ( 'financials'[Date] ),
ERROR ( "Uh oh." ),
VAR PREV_QUARTER =
CALCULATE (
SUM ( 'financials'[Sales] ),
DATEADD ( 'financials'[Date], -1, QUARTER )
)
RETURN
...
hashnotes.hashnode.dev1 min read