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.
I have two slicers :
I want to calculate the total of product with the date_sold between the year selected and the month selected
and the last year the same month.
Example :
Current selection :
month : january
year : 2022
the range : january 2021 - january 2022
The measure of count is simple : CountProducts = COUNT(FCT_Table[ProductID])
Solved! Go to Solution.
YourMeasure=
CALCULATE(COUNT(FCT_Table[ProductID])
DATESINPERIOD(FCT_Table[date_sold],
LASTDATE(FCT_Table[date_sold]),-12, MONTH),
USERELATIONSHIP(dim_calendrier[id],FCT_Table[date_sold]))
YourMeasure=
CALCULATE(COUNT(FCT_Table[ProductID])
DATESINPERIOD(FCT_Table[date_sold],
LASTDATE(FCT_Table[date_sold]),-12, MONTH),
USERELATIONSHIP(dim_calendrier[id],FCT_Table[date_sold]))
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 |
---|---|
86 | |
84 | |
66 | |
62 | |
59 |
User | Count |
---|---|
197 | |
116 | |
107 | |
77 | |
70 |