I am trying to write an equation that will project the gross profit based on gross profit and # of days between July 1st, 2021 and last date of service for ALL prescribers.
When I filter by one prescriber, the equation is using the difference of dates from the first date the doctor wrote a prescription to the date of their most recent prescription sent (date of service slicer starts at 7/13 instead of 7/1 and calculation is based on 62 days instead of 74 days).
The equation I am using right now is
Projected GP =
( SUM ( 'GP 2'[Gross Profit] ) )
/ DATEDIFF (
FIRSTDATE ( 'GP 2'[Date Of Service] ),
LASTDATE ( 'GP 2'[Date Of Service] ),
DAY
) * 365
When I filter by one prescriber, the equation is using the difference of dates from the first date the doctor wrote a prescription to the date of their most recent prescription sent (date of service slicer starts at 7/13 instead of 7/1 and calculation is based on 62 days instead of 74 days).
The equation I am using right now is
Projected GP =
( SUM ( 'GP 2'[Gross Profit] ) )
/ DATEDIFF (
FIRSTDATE ( 'GP 2'[Date Of Service] ),
LASTDATE ( 'GP 2'[Date Of Service] ),
DAY
) * 365
