Cakz Primz
Board Regular
- Joined
- Dec 4, 2016
- Messages
- 102
- Office Version
- 365
- Platform
- Windows
Dear MrExcel,
I have a table, SalesTable with a column header OrderDate, which contains date.
In column OrderDate, I have data of order date, between year 2017 until year 2020 (2017, 2018, 2019, 2020)
How do I measures in DAX to know that the distinct year is 4?
# Years =
DISTINCT(SalesTable[OrderDate].[Year])
Thank you very much
Prima - Indonesia
I have a table, SalesTable with a column header OrderDate, which contains date.
In column OrderDate, I have data of order date, between year 2017 until year 2020 (2017, 2018, 2019, 2020)
How do I measures in DAX to know that the distinct year is 4?
# Years =
DISTINCT(SalesTable[OrderDate].[Year])
Thank you very much
Prima - Indonesia