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 close dates for items in a column (see snap below), some of which are in 2022. A separate column has revenues for each item. How do I create a measure that calculates the total revenue for all items that were closed in 2022?:
Solved! Go to Solution.
@james_wood , Measure
calculate(sum(Table[Revenue]), filter(Table, year(Table[Close date]) = 2022))
or
calculate(sum(Table[Revenue]), filter(Table, year(Table[Close date]) =year(Today()) ))
@james_wood , Measure
calculate(sum(Table[Revenue]), filter(Table, year(Table[Close date]) = 2022))
or
calculate(sum(Table[Revenue]), filter(Table, year(Table[Close date]) =year(Today()) ))
User | Count |
---|---|
77 | |
75 | |
67 | |
65 | |
47 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
65 |