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.
Hello folks, I'm trying to calculate the delta between two dates, I'm sending the The File .
Is there a better way to do it? Can anyone help?
Thanks!
Solved! Go to Solution.
You need to disconnect your date tables, and use USERELATIONSHIP()
see attached
Inbetween = CALCULATE(sum('Fact'[Sales]),DATESBETWEEN('Fact'[Date],min(CalendarFact[Date]),max(CalendarFactDest[Date])))
Amazing, I wish someday I'll be just as good!
Delta in what currency? Days? Months? Years?
I'd like to see the result for this calculation
Just as curiosity, do you think we can have the comulative sum between selected months? 🙂
Inbetween = CALCULATE(sum('Fact'[Sales]),DATESBETWEEN('Fact'[Date],min(CalendarFact[Date]),max(CalendarFactDest[Date])))
Hello there, its me again, would you know how can I set a green color font whenever the value is higher than or equal to 1? Keeping the red rule. Thanks!
You would add a second rule from 0 to max.
Nice, thanks!
Awesome!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
61 | |
55 |
User | Count |
---|---|
179 | |
108 | |
105 | |
71 | |
70 |