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 Team,
I have the data of customers for 6 months(Jan - Jun) where I have to show the comparison for Current month (June) vs Previous months (January - May). How can I create this logic to compare total number of customers for above comparison?
also please suggest some visuals.
Solved! Go to Solution.
HI @Anshu_Joshi,
It sounds like a common rolling aggregate calculate requirements. For this scenario, I you can extract the current date to store in variable. Then you can use that variable with date function to get result and as condition in expression to filter and limit the calculation ranges.
formula =
VAR currDate =
MAX ( Table[Date] )
RETURN
CALCULATE (
SUM ( Table[Value] ),
FILTER (
ALLSELECTED ( Table ),
[Date]
>= DATE ( YEAR ( currDate ), MONTH ( currDate ) - 5, DAY ( currDate ) )
&& [Date] <= currDate
)
)
Regards,
Xiaoxin Sheng
HI @Anshu_Joshi,
It sounds like a common rolling aggregate calculate requirements. For this scenario, I you can extract the current date to store in variable. Then you can use that variable with date function to get result and as condition in expression to filter and limit the calculation ranges.
formula =
VAR currDate =
MAX ( Table[Date] )
RETURN
CALCULATE (
SUM ( Table[Value] ),
FILTER (
ALLSELECTED ( Table ),
[Date]
>= DATE ( YEAR ( currDate ), MONTH ( currDate ) - 5, DAY ( currDate ) )
&& [Date] <= currDate
)
)
Regards,
Xiaoxin Sheng
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 |
---|---|
87 | |
82 | |
65 | |
64 | |
56 |
User | Count |
---|---|
171 | |
111 | |
109 | |
72 | |
71 |