Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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
User | Count |
---|---|
101 | |
90 | |
80 | |
71 | |
70 |
User | Count |
---|---|
114 | |
98 | |
97 | |
73 | |
72 |