Forum Discussion
Add an instance on refresh data
Hi, I wanted to make a dashboard where i am updating today's data as below Sales as on Today (22-Apr-2021) Product Sales Television 250 Mobile 475 and I wanted to ...
Anonymous , for last 5 days you can have measure like this
New measure =
var _max = today() // maxx(allselected('Date', 'Date'[date])
var _min = _max -5
return
calculate(sum(Table[Sales]), filter(all('Date'), 'Date'[date] >=Min && 'Date'[date] <=_max && Date[Date] <=max(Date[Date])))
date on axis, product on legend as per need