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.
Here is how my data looks.
Question: How do I group by Year 2016 Vs 2017 based on total(MetricValue) in PowerBI.
DateAdded | SalesFunnel | MetricCategory | MetricName | MetricValue |
3/1/2016 0:00 | eCom | Demand | eComStep1 | 1590 |
3/1/2016 0:00 | LeadForms | Demand | LeadForms | 746 |
3/1/2016 0:00 | Phone | Demand | SalesCalls | 1937 |
3/2/2016 0:00 | eCom | Demand | eComStep1 | 1240 |
3/2/2016 0:00 | LeadForms | Demand | LeadForms | 794 |
3/2/2016 0:00 | Phone | Demand | SalesCalls | 1759 |
Solved! Go to Solution.
Hi 101Francisco,
Create a new calculate column using DAX:
Year = YEAR(Table1[DateAdded])
Then create a measure using DAX:
Total of 2016 = CALCULATE(SUM(Table1[MetricValue]), ALLEXCEPT(Table1, Table1[Year]))
Regards,
Jimmy Tao
Hi 101Francisco,
Create a new calculate column using DAX:
Year = YEAR(Table1[DateAdded])
Then create a measure using DAX:
Total of 2016 = CALCULATE(SUM(Table1[MetricValue]), ALLEXCEPT(Table1, Table1[Year]))
Regards,
Jimmy Tao
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 |
---|---|
89 | |
81 | |
65 | |
65 | |
61 |
User | Count |
---|---|
170 | |
115 | |
100 | |
73 | |
67 |