Forum Discussion
Previous Date value based on the date selection
Hi Anonymous ,
Use independent date table as slicer and create a measure like below:
Measure = var _previous = EDATE(MAX('Date'[date]),-1) return CALCULATE(SUM(TransactionTable[value]),FILTER(TransactionTable,TransactionTable[Date]=_previous))Or create a measure as below and add it to visual filter set value = 1:
Measure 2 = var _previous = EDATE(MAX('Date'[date]),-1) return IF(SELECTEDVALUE('TransactionTable'[Date])=_previous,1,0)Best Regards,
Jay
Super UserAnonymous , You should prefer date table. if two date are selected , measure like this for min date
new measure =
var _max = minx(allselected(Date),Date[Date])
return
calculate( SUM('TransactionTable'[Value), filter('Date', 'Date'[Date] =_min ))
For the last date the previous date refer
Day Intelligence - Last day, last non continous day
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c3243d1f9
Thank you amitchandak for the reply. I have tried this. And I cant use MINX because I need the previpus days data(If the date range is 2-01-2022 to 04-01-2022, I need the 3rd data. and if the range is from 02-01-2022 to 05-01-2022, I need 04-01-2022 data). So I have tried _max-1 in the filter context.
Still, it is giving me the values in the table as blanks and totals are correct.
- amitchandak
Anonymous , Then try
new measure =
var _max = maxx(allselected(Date),Date[Date]) -1
return
calculate( SUM('TransactionTable'[Value), filter('Date', 'Date'[Date] =_max ))amitchandak Thank you for the reply. I have tried that with maxdate-1. Still it is showing the totals only not the values.
If the date range is from 02-01-2022 to 04-01-2022, my table need to show the data related to 03-01-2022.
Team Value X 2 Y 5 Z 1 I need the output by the Team name like above but im getting the resuts as below with only totals not the values.
Team Value X Y Z Total 8 Can anyone please help me out?
Thanks in advance,
Vishnu Priya
ryan_mayuAnonymous
pls see the attachment below