Forum Discussion
Solved
What am i doing wrong
Hello i have this messure, the ideea is to show value from 7 days back, if i select a date, from that date , if nothing is selected from today - 7 so this is tha data which is working for the today...
Hi cristianj, your calculation looks to be overcomplicated... Is there a spicific reason why you wrote it in this way? You can achieve the similar result much simplier:
Sales 7 days before = VAR _CurrentDate = SELECTEDVALUE( CalendarTable[Date] ) //we need to remember the currently selected date, because we0ll overwrite it with Calculate() later RETURN CALCULATE( SUM( Sales[Sales] ), CalendarTable[Date] = _CurrentDate - 7 )Let me know if it works or if I misunderstood your question.
Thank you i will change and try,
i write it in such way, because if is nothing selected, it has to use the today as a starting point, but i try and let you know
and i try to make it a messure, because i need to display the current value(today or the selected one), current value 7 days back and current value 14 days back