Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi
how to write DAX function about , last three month leaves - same period last years ?
Thanks
sreenivasa
Solved! Go to Solution.
Hi @Anonymous,
Could you try using the formulas below to see if it works in your scenario?
three month leaves = VAR currentDate = MAX ( Date[Date] ) RETURN CALCULATE ( SUM ( Table1[Value] ), DATESINPERIOD ( Date[Date], EDATE ( currentDate, -3 ), 3, MONTH ) )
three month leaves same period last year =
VAR currentDate =
MAX ( Date[Date] )
RETURN
CALCULATE (
SUM ( Table1[Value] ),
DATESINPERIOD ( Date[Date], EDATE ( currentDate, -15 ), 3, MONTH )
)
Regards
Hi @Anonymous,
Could you try using the formulas below to see if it works in your scenario?
three month leaves = VAR currentDate = MAX ( Date[Date] ) RETURN CALCULATE ( SUM ( Table1[Value] ), DATESINPERIOD ( Date[Date], EDATE ( currentDate, -3 ), 3, MONTH ) )
three month leaves same period last year =
VAR currentDate =
MAX ( Date[Date] )
RETURN
CALCULATE (
SUM ( Table1[Value] ),
DATESINPERIOD ( Date[Date], EDATE ( currentDate, -15 ), 3, MONTH )
)
Regards
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |