Forum Discussion
Getting the Last purchase date in Cards
- 1 year ago
Easley08 Create a measure to get the latest purchase date:
Latest Purchase Date = MAX(Sales[Purchase Date])
Create a measure to get the outlet name of the latest purchase:
Latest Outlet Name =
CALCULATE(
FIRSTNONBLANK(Sales[Outlet Name], 1),
Sales[Purchase Date] = [Latest Purchase Date]
)Create a measure to get the purchase date of the latest purchase:
Latest Purchase Date Display =
CALCULATE(
MAX(Sales[Purchase Date]),
Sales[Purchase Date] = [Latest Purchase Date]
)Create a measure to get the LP Year of the latest purchase:
Latest LP Year =
CALCULATE(
MAX(Sales[LP Year]),
Sales[Purchase Date] = [Latest Purchase Date]
)
Easley08 Create a measure to get the latest purchase date:
Latest Purchase Date = MAX(Sales[Purchase Date])
Create a measure to get the outlet name of the latest purchase:
Latest Outlet Name =
CALCULATE(
FIRSTNONBLANK(Sales[Outlet Name], 1),
Sales[Purchase Date] = [Latest Purchase Date]
)
Create a measure to get the purchase date of the latest purchase:
Latest Purchase Date Display =
CALCULATE(
MAX(Sales[Purchase Date]),
Sales[Purchase Date] = [Latest Purchase Date]
)
Create a measure to get the LP Year of the latest purchase:
Latest LP Year =
CALCULATE(
MAX(Sales[LP Year]),
Sales[Purchase Date] = [Latest Purchase Date]
)
Hi sir im getting error for this