Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello guys,
I'm coming up to you with an issue that has been frying my brain lately. Long story short, right now I'm comparing the data of two dates (this week vs previous week) hence on my calendar slicer, I have to click on two dates: but the objective of the user is to just click on one date (April 10) and it automatically compares with the data of the previous date (April 3rd)
Any suggestions will be more than welcomed
Thank you 🙂
Solved! Go to Solution.
hi @danextian ,
Thanks for all the support. The user decided to go with a different approach instead.
Hi @yannick90 ,
Have you tried my approach in the PBIX i've previously shared? If that doesn't work, please share sanitized copy of your pbix (anonimized data, a representation of your data model) ?
Proud to be a Super User!
hi @danextian ,
Thanks for all the support. The user decided to go with a different approach instead.
Hi @danextian,
Here is a sample of my date tables:
main calendar
additional columns:
if I select May 1st and April 24th, below is the result:
but I want to get the same result just by selecting May 1st
Are you trying to compute for the value in the last 7 days a week ago or the value 7 days ago?
Proud to be a Super User!
Hello @danextian,
I'm a bit confused by your statement. let me give a bit of context, the file is updated every monday. For example it was updated on April 24th, then May 1st and so on. So the scenario goes like this (take the data of "this week which is May 1st" and compare it to the data of last week which is April 24th
There is already a formula in place that is giving me the value of this week (2,8 millions) and last week (2,9 millions).
Now the objective is to get the value of difference and variation by just selecting this week's date rather than selecting this week and last week
Let me know if it answers your question
Thanks
What i was trying to say was, if today is Jan 30, are you trying to compare Jan 30 with Jan 23 or the from Jan 23 to 30 vs Jan 16 to Jan 22?
Proud to be a Super User!
Hi @yannick90 ,
Please try this
Value Last Week =
CALCULATE (
[Sum of Values],
FILTER ( ALL ( Dates ), Dates[Date] = MAX ( Dates[Date] ) - 7 )
)
If this doesn't work, please post a sample data and your dates table.
Proud to be a Super User!
Hi @danextian ,
this is what I typed:
I also tried the below but no luck:
CalcInvLastWeek RsmC = CALCULATE(SUM('table'[data)]),
FILTER(ALLSELECTED('table'),'table'[date]=MAX('table'[date])-7))
thanks you