Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Experts
How would you change the following DAX to give you end of last month - as opposed to start of current month..... see hightlight VAR
Solved! Go to Solution.
@Anonymous , Last month end date id
eomonth(today() ,-1)
eomonth(maxx(allselected('Date'),'Date'[Date]) ,-1)
what do you want to get there?
@Anonymous , Last month end date id
eomonth(today() ,-1)
eomonth(maxx(allselected('Date'),'Date'[Date]) ,-1)
what do you want to get there?
Hi Amit - I want to update my measure to give last 12 months excluding current month based on calender table....
STUCK
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |