Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

katoma

BUG: DATESINPERIOD Function not accepting Enum Interval anymore

Submitted by on ‎04-19-2018 01:45 AM

Function  definiton:

 https://msdn.microsoft.com/query-bi/dax/datesinperiod-function-dax

Problem:

 Can't save/apply/change measure anymore due to not accepting any interval parameter

Measure:

 avg something = CALCULATE(AVERAGE('Table'[something]),
  DATESINPERIOD('Table'[Date],TODAY(), -7, DAY))

Version:

 Version: 2.57.5068.721 64-bit (April 2018)

Solution/Fix:

  avg something = CALCULATE(AVERAGE('Table'[something]),
  DATESINPERIOD('Table'[Date],TODAY(), -7,0 , DAY))

 

Function is defined with integer and not number. Parser seems to be broken

Status: Needs Info
See more ideas labeled with:
4 Comments (4 New)
Comments
v-jiascu-msft
Employee
Employee
‎04-23-2018 12:35 AM

Hi @katoma,

 

Can you share you pbix file? It seems fine in my test.

DATESINPERIOD_Function_not_accepting_Enum_Interval_anymore

 

 

Best Regards,

Dale

Vicky_Song
Impactful Individual
Impactful Individual
‎04-23-2018 12:37 AM
Status changed to: Needs Info
 
katoma
Regular Visitor
‎05-08-2018 12:56 AM

@v-jiascu-msft did you try the excact version? this popped up like a month ago. i can share pbit but where to, to whom?

v-jiascu-msft
Employee
Employee
‎05-08-2018 01:12 AM

Hi @katoma,

 

Yes, I tried with the exact version. You can upload the file to a cloud drive like OneDrive, Dropbox. Then send me a message of the download link.

 

Best Regards,

Dale

Idea Statuses