Quarter Starting and Ending Value

[gvb238]

Hi Team,

I have one Requirement. I have thw data like This.

DateKey     Quarter      Open       Join      Close

20180101     Q1           100         20         120

20180201     Q1            120        30          150

20180301     Q1            150        10          160

20180401     Q2            160        20          180

20180501     Q2            180        20          200

But i want to show them to like this

Quarter      Open       Join      Close

   Q1           100         60         160

    Q2          160         40          200

Here 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.

[Ashish_Mathur]

Hi,

You may download my PBI file from here.

Hope this helps.

[v-juanli-msft · Accepted solution]

Hi @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]))

Best Regards

Maggie