Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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 , or any other selection
Solved! Go to Solution.
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.
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 werry much, with your help i change the formula and now it is working
I believe there is something related to Context Transition - Understanding context transition in DAX - SQLBI. Unfortunately I can't dedicate more time to debug your code but you can do so by yourself after carefully reading this article 🙂
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
I see, here is the updated code (read comment for more details on it):
Sales 7 days before =
VAR _CurrentDate =
SELECTEDVALUE(
CalendarTable[Date],
MAXX( ALL( CalendarTable[Date] ),
TODAY()
)
)
//we need to remember the currently selected date, because we'll overwrite it with Calculate() later. SELECTEDVALUE() return only 1 value, so if multiple dates are selected, we need to return an alternative result - the second argument of the formula. In this case I used Today() to obtain today's date, but you can replace it with any other date, for instance absolute MAX of CalendarTable. Simply replace the code of variable from the above with the following:
/*
VAR _CurrentDate =
SELECTEDVALUE(
CalendarTable[Date],
MAXX(
ALL( CalendarTable[Date] ),
CalendarTable[Date]
)
)
*/
RETURN
CALCULATE(
SUM( Sales[Sales] ),
CalendarTable[Date] = _CurrentDate - 7
)
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
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
87 | |
82 | |
71 | |
49 |
User | Count |
---|---|
143 | |
120 | |
110 | |
60 | |
57 |