Forum Discussion

yazenbarakat123's avatar
yazenbarakat123
Helper I
4 years ago
Solved

Time intelligence Function

Hello All!    Im currently trying to write a Dax query to retrive the  "Current Date" for the previous month in a scheduling Report.      Each Scheduled acticty has a Baseline date and a current...
  • johnt75's avatar
    johnt75
    4 years ago

    You could create a measure like

    Previous Month =
LOOKUPVALUE (
    'Table'[Current Month],
    'Table'[Activity ID], SELECTEDVALUE ( 'Table'[Activity ID] ),
    'Table'[Reporting date], EOMONTH ( SELECTEDVALUE ( 'Table'[Reporting Month] ), -2 ) + 1,
    BLANK ()
)
yazenbarakat123's avatar
yazenbarakat123
Helper I
4 years ago

One last question the first activity dosent capture the previous months current date for some reason 

 

ā€ƒ

johnt75's avatar
johnt75
Super User
4 years ago

Try using Power Query to change the type of the reporting date column to date rather than datetime. Its possible that there are some microseconds, not being displayed, which means the two values don't match