Dynamic Measure Required with two slicer
Hi Folks, I'm trying to develop the dashboard by comparing two months and their uses of two slicers. I prepared the dashboard using Excel Formulas. please help to develop Power-BI As the Raw data is attached Excel is available. please refer it Google Drive Link for Excel File Please feel free to contact for more info if required. RAW Data Period Account Value X Value Y Value Z Fix Tata 4 3 5 Fix Birla 6 7 8 Fix Adani 7 8 9 Fix RIL 8 9 10 Fix Tata 9 10 11 Fix Birla 10 11 12 Jan Adani 11 12 13 Jan RIL 12 13 14 Jan Tata 13 14 15 Jan Birla 14 15 16 Jan Adani 15 16 17 Feb RIL 16 17 18 Feb Tata 17 18 19 Feb Birla 18 19 20 Feb Adani 19 20 21 Feb RIL 20 21 22 March Tata 21 22 23 March Birla 22 23 24 March Adani 23 24 25 March RIL 24 25 26 March Tata 25 26 27 March Birla 26 27 28 March Adani 27 28 29 April RIL 28 29 30 April Tata 29 30 31 April Birla 30 31 32 April Adani 31 32 33 April RIL 32 33 34 April Tata 33 34 35 Regards, MOHIT
Need Help _ DAX Week starting and Week ending total score for students
Hi All, I need your help your help writing a DAX statement (conditional/custom column) or Power query steps for the same to achieve the following result, here's a table that I am working on , Thank you so much in advance. Student Name Score Year Week WeekEnding StudentID John 85.2 2023 39 Sunday, Sep 24, 2023 121 John 85.2 2023 40 Sunday, Oct 1, 2023 121 John 51.7 2023 41 Sunday, Oct 8, 2023 121 John 54.3 2023 42 Sunday, Oct 15, 2023 121 John 38.3 2023 43 Sunday, Oct 22, 2023 121 John 20 2023 44 Sunday, Oct 29, 2023 121 John 41.9 2023 45 Sunday, Nov 5, 2023 121 John 50.4 2023 46 Sunday, Nov 12, 2023 121 John 30.9 2023 47 Sunday, Nov 19, 2023 121 John 52.6 2023 48 Sunday, Nov 26, 2023 121 John 0 2023 49 Sunday, Dec 3, 2023 121 I need the week starting and ending running totals of the score column, Please see the expected result table. Expected result Student Name Score Year Week WeekEnding StudentID Score Week Beginning Score Week Ending John 85.2 2023 39 Sunday, Sep 24, 2023 121 0 85.2 John 85.2 2023 40 Sunday, Oct 1, 2023 121 85.2 170.4 John 51.7 2023 41 Sunday, Oct 8, 2023 121 170.4 222.1 John 54.3 2023 42 Sunday, Oct 15, 2023 121 222.1 276.4 John 38.3 2023 43 Sunday, Oct 22, 2023 121 276.4 314.7 John 20 2023 44 Sunday, Oct 29, 2023 121 314.7 334.7 John 41.9 2023 45 Sunday, Nov 5, 2023 121 334.7 376.6 John 50.4 2023 46 Sunday, Nov 12, 2023 121 376.6 427 John 30.9 2023 47 Sunday, Nov 19, 2023 121 427 457.9 John 52.6 2023 48 Sunday, Nov 26, 2023 121 457.9 510.5 John 0 2023 49 Sunday, Dec 3, 2023 121 510.5 510.5
