Forum Discussion

GillyGils's avatar
GillyGils
Frequent Visitor
4 years ago
Solved

LAG Conversion from MDX to DAX

Hi All, I've the following MDX formula i'm trying to convert to DAX: ([Time Dimension].[Date].CurrentMember.lag(1), [Measures].[Total Available])   I've been trying to adjust the code below s...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi GillyGils ,

    If there are only 'End of Month Dates' in your fact table. Please have a try.

    Create a measure.

    Measure1 = 
VAR _date =
MAX ( 'Table'[date] )
VAR _pre_date =
EOMONTH ( _date,-1)
VAR _value =
CALCULATE (
[total available],
FILTER ( ALL ( 'Table'), 'Table'[date] = _pre_date )
)
RETURN
_value

    Best Regards

    Community Support Team _ Polly

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi GillyGils ,

I have created a simple sample, please refer to it to see if it helps you.

Create a measure.

Measure =
VAR _date =
    MAX ( 'Table'[date] )
VAR _pre_date =
    EDATE ( _date, -1 )
VAR _value =
    CALCULATE (
        [total available],
        FILTER ( ALL ( 'Table'[date], 'Table'[total] ), 'Table'[date] = _pre_date )
    )
RETURN
    _value

 

If I have misunderstood your meaning, please provide more details with your desired output and pbix file without  priavcy information.

 

Best Regards

Community Support Team _ Polly

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.