Quarter Starting and Ending Value

Question

Hi Team,I have one Requirement. I have thw data like This.&nbsp;DateKey&nbsp; &nbsp; &nbsp;Quarter&nbsp; &nbsp; &nbsp; Open&nbsp; &nbsp; &nbsp; &nbsp;Join&nbsp; &nbsp; &nbsp; Close20180101&nbsp; &nbsp; &nbsp;Q1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;12020180201&nbsp; &nbsp; &nbsp;Q1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 120&nbsp; &nbsp; &nbsp; &nbsp; 30&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 15020180301&nbsp; &nbsp; &nbsp;Q1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 150&nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 16020180401&nbsp; &nbsp; &nbsp;Q2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 160&nbsp; &nbsp; &nbsp; &nbsp; 20&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 18020180501&nbsp; &nbsp; &nbsp;Q2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 180&nbsp; &nbsp; &nbsp; &nbsp; 20&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 200&nbsp;But i want to show them to like thisQuarter&nbsp; &nbsp; &nbsp; Open&nbsp; &nbsp; &nbsp; &nbsp;Join&nbsp; &nbsp; &nbsp; Close&nbsp; &nbsp;Q1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;60&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;160&nbsp; &nbsp; Q2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 160&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;40&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 200Here Open value is Starting of the Quarter and close value is the closing value of the quarter and join value is sum of the join values in the quarter.&nbsp;&nbsp;

v-juanli-msft · Accepted Answer

Hi&nbsp;gvb238
Create measures
Measure-open = CALCULATE(MIN(Table1[Open]),ALLEXCEPT(Table1,Table1[Quarter]))

Measure-join = CALCULATE(SUM(Table1[Join]),ALLEXCEPT(Table1,Table1[Quarter]))

Measure-close = CALCULATE(MAX(Table1[Close]),ALLEXCEPT(Table1,Table1[Quarter]))

&nbsp;
&nbsp;
Best Regards
Maggie

Forum Discussion

Quarter Starting and Ending Value

2 Replies

Related content

Start and end date of the current Quarter

Start and end of previous Quarter

EBIT Financial Bridge - Dynamic Start and End

User Group Leader Get Started Guide

Convert Quarter Year, To Start Of Quarter Date Column Of Each Quarter