View My Drafts
Hi Andrew,Here's an example of the DAX code:
Count delta = VAR nextDayCount = CALCULATE ( COUNTROWS ( 'Sales Invoices' ), DATEADD ( DateDim[Date], 1, DAY ) ) RETURN [Record Count] - nextDayCountIn this example, table 'Sales Invoices' contains the transactions. Each transaction has a date and that date is liked to a dateDim table. (Relationship in Power BI)The calculated measure "Record Count" is the count of records (Record Count = COUNTROWS('Sales Invoices')).