Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Difference between VALUES(Date[Month]) and VALUES(Date[Day])

For context, please see previous question   I have DAX that calculates the YTD average on an ongoing basis of a measure (see below and previous question for more detail):     where the blue...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    I actually managed to solve my issue! By using the following DAX code:

     IF(
	ISFILTERED('Date Table'[Datekey]),
	ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column."),
	TOTALYTD([Monthly Reliability], 'Date Table'[Datekey].[Date])
)
Anonymous's avatar
Anonymous
Not applicable
5 years ago

I actually managed to solve my issue! By using the following DAX code:

 IF(
	ISFILTERED('Date Table'[Datekey]),
	ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column."),
	TOTALYTD([Monthly Reliability], 'Date Table'[Datekey].[Date])
)