DAX YTD, QTD and MTD calculations

• David Jackson

  SSCertifiable

  Points: 6414

  More actions

  September 28, 2018 at 7:08 am

  #364222

  Hello
  I am trying to calculate the above functions on a fairly simple Azure Hosted Analysis Services Model.
  I have a measure Quotes[QuotesCount] defined as QuotesCount:=COUNT(Quotes[QuoteID])
  This correctly returns a figure in the millions
  I have a date table called CalendarDate with a unique PK column called PKData
  I then have a measure called  called BudgetYTD:=CALCULATE(Quotes[QuotesCount], DATESYTD(CalendarDate[PKDate]))
  This does return a number. However, both
  BudgetQTD:=CALCULATE(Quotes[QuotesCount], DATESQTD(CalendarDate[PKDate]))
  and 

  BudgetMTD:=CALCULATE(Quotes[QuotesCount], DATESMTD(CalendarDate[PKDate]))
  both return (blank)
  I have also Tried TOTALYTD, TOTALQTD and TOTALMTD with the same results.

  I am using the latest version of VS 2017, (I know it is the latest, it has crashed on me 3 times today!) and I am using an integrated workspace.

  Anyone seeing this at the moment?  Am I doing something dumb?

  tia
  Dave

  ---

  http://glossopian.co.uk/
  "I don't know what I don't know."