Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Dear all,
My source looks like this:
Delivery Period | Economical Period | Value |
January 2020 | January 2020 | 100 |
January 2020 | February 2020 | 50 |
February 2020 | February 2020 | 20 |
February 2020 | March 2020 | 30 |
What I need is my output table to ONLY show the INITIAL value of the economical period and to leave the other rows empty.
Desired output table:
Delivery Period | Economical Period | Initial Value |
January 2020 | January 2020 | 100 |
January 2020 | February 2020 | 0 |
February 2020 | February 2020 | 20 |
February 2020 | March 2020 | 0 |
So basically, I only need the table to show the value if delivery period = economical period.
The total of the measue should be 120 (100 + 20).
Which measure can I use to achieve this result?
Thank you!
Solved! Go to Solution.
@AVIE ,
Try a measure like
calculate(Sum(Table[Value]), filter(Table, Table[Delivery Period]=Table[Economical Period]))
@AVIE ,
Try a measure like
calculate(Sum(Table[Value]), filter(Table, Table[Delivery Period]=Table[Economical Period]))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |