Forum Discussion

tvaishnav's avatar
tvaishnav
Icon for Helper IV rankHelper IV
4 years ago

DAX error : A single value for column 'Date' in table 'Date' cannot be determined.

I am new to DAX and trying learn it. So I am essentially looking for an explanation as to what is causing the error.   Following formula works fine       AverageX = Averagex( ...
DAX
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
4 years ago

tvaishnav Because you have an errant paren ). The second formula should be:

AverageX = Averagex(
                  'Date'[Date]
                   ,Fact_Hours[SUM Hours]
                    )