Forum Discussion
Primera compra
Hi YOSIEMPREYO12 ,
Thank you for reaching out to the Microsoft Community Forum.
This measure ignores all filters, including date filters
First Purchase Date =
CALCULATE(
MIN('Table'[Date]),
ALL('Table')
)This measure ignores filtering only on the Date column
First Purchase Date =
CALCULATE(
MIN('Table'[Date]),
ALL('Table'[Date])
)If my response has resolved your query, please mark it as the Accepted Solution to assist others. Additionally, a 'Kudos' would be appreciated if you found my response helpful.
Thank youYou cannot show first date in the Date column, because it is being filtered. You have to use different column or visual to display it. You can show first Purchase Amount is the separate column as well:
First Purchase = CALCULATE(SUM('Table'[Amount]),
TOPN(1, ALL('Table'), 'Table'[Date], ASC),
'Table'[Location] = SELECTEDVALUE('Table'[Location]))
No tengo mucho para mostrar son solo 3 columnas
Necesito la primera fecha de compra sin importar el filtro que tenga puesto
Solo eso
Gracias
Yes, it is possible. You need to build DAX measure using CALCULATE and filter ALL(Table[Dates])
Links to review:
https://learn.microsoft.com/en-us/dax/all-function-dax
https://learn.microsoft.com/en-us/dax/calculate-function-dax
Pero eso no me trae la primera fecha
Falta algo me parece
You cannot show first date in the Date column, because it is being filtered. You have to use different column or visual to display it. You can show first Purchase Amount is the separate column as well:
First Purchase = CALCULATE(SUM('Table'[Amount]),
TOPN(1, ALL('Table'), 'Table'[Date], ASC),
'Table'[Location] = SELECTEDVALUE('Table'[Location]))