Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi all,
Anyone knows how to add the a three days + range, based on user selections on 'Date Début effective' ?
Cheers
Solved! Go to Solution.
Hi @Anonymous ,
Do you want to achive this output below? If we select the date in date slicer, the card visual will show the date of the date we selected +3.
If that is your case, you could use the formula.
Measure = CALCULATE(SELECTEDVALUE(Sheet9[Date]))+3
If you still need help, please share your data sample and your desired output so that we can help further on it.
Best Regards,
Cherry
Hi @Anonymous ,
Do you want to achive this output below? If we select the date in date slicer, the card visual will show the date of the date we selected +3.
If that is your case, you could use the formula.
Measure = CALCULATE(SELECTEDVALUE(Sheet9[Date]))+3
If you still need help, please share your data sample and your desired output so that we can help further on it.
Best Regards,
Cherry
You mean like:
% Onboarding = var Date1 = CALCULATE(SELECTEDVALUE(Table1[Date Début Effective])) + 3 var Date2 = CALCULATE(SELECTEDVALUE(Table1[Date Fin Effective])) Return IF(SELECTEDVALUE(t_Datas[Date])=Date1; Calculate( DIVIDE([M_Filter_MissionID S04] ; [M_Count_MissionID]))
?
i Greg,
More useful information:
1) dont seem to be able to convert the new column into a "Whole Number" so that then I can "+3"
2) Doing the exact same for my Date column in my calendar table and works as a charm.
3) Both columns have the same date format.
Is there a reason for this awkward behaviour? I sometimes dont get the engine behind.
Cheers.
Hi @Anonymous ,
Have you solved your problem?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please feel free to ask.
Best Regards,
Cherry
Can anyone help me please?
It's increasing the days and not the months as it's supposed to.
THANKS !
FORMULA:
Hi Greg,
That was in fact my first attempt. However, I do not get the expected result.
It just keeps retrieving 3 if I add '.MonthNo' or '02-01-1900 00:00:00'.
What am I doing wrong ?
Thank you so much!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
91 | |
89 | |
79 | |
69 | |
68 |
User | Count |
---|---|
222 | |
128 | |
117 | |
82 | |
77 |