Time Intelligence using Measure which returns a Date

Question

Dear all,&nbsp;I created a measure that returns a date (Waiting Period Ends); I need to generate another measure that returns the start of the following month respecting Waiting Period Ends.&nbsp;Waiting Period Ends = if([Hours Month (-4)]&gt;129.999,[Comparison_MaxDate_StartOftMonth(-4)]+59,&nbsp; &nbsp; &nbsp; &nbsp; if([Hours Month (-3)]&gt;129.999,[Comparison_MaxDate_StartOftMonth(-3)]+59,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if([Hours Month (-2)]&gt;129.999,[Comparison_MaxDate_StartOftMonth(-2)]+59,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if([Hours Month (-1)]&gt;129.999,[Comparison_MaxDate_StartOftMonth(-1)]+59,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if([Hours Current Month]&gt;129.999,[Comparison_MaxDate_StartOfCurrentMonth]+59&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )))))&nbsp;I tried to use time intelligence DAX expressions like STARTOFMONTH, and DATEADD, but i failed&nbsp;&nbsp;&nbsp;For example,if&nbsp;Waiting Period Ends returns 12/14/2022the new measure should return: 1/1/2023 (first day of the next month)&nbsp;Thank you, I appreciate your time.

greg_deckler · Accepted Answer

FelipeScheihing&nbsp;Try:
Measure = 
  VAR __EOM = EOMONTH([Waiting Period Ends],1)
  VAR __Result = DATE(YEAR(__EOM), MONTH(__EOM), 1)
RETURN
  __Result
Also, time intelligence functions are evil.&nbsp;You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000Also:https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008

Forum Discussion

Time Intelligence using Measure which returns a Date

2 Replies

Related content

Measure returning incorrect value

Measure is returning BLANK

DAX Measure Returning Incorrect Results

Create Measure to Return Highest Value

Help with Date intelligence