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
Parent and child calculation
i have a parent and child table, i wanted to calculate the values with respect to their root parents like a family tree Parent Child Value Site1 Site2 10 Site2 Site3 20 Site3 Site4 15 The output should be, Parent Child Value Output Site1 Site2 10 10 Site2 Site3 20 30 Site3 Site4 15 45 Thanks in advance
I need help to create a new table from another one
I don't know if this is tricky or is just me, but here goes nothing. I have one table with a group of columns that are months and another group of columns that are also months, each group have a different context in its values; one group is a planified budget, the other group is the real disbursement. Something like this: id title jan_planified_amount feb_planified_amount (…) jan_real_amount feb_real_amount (...) 1 example_1 $500,00 $0,00 (…) $0,00 $500,00 (…) So I tried creating two new tables, one for each group and unpivot the columns, keeping the ids, the months and the amount. Then I create a relation many to many and create a new table with only ids, but when I tried putting the values in a chart it does not work. So I need another way to relate these tables or create only one table with both values like this: id title month planified amount real amount 1 example_1 jan $500,00 $0,00 1 example_1 feb $0,00 $500,00 1 example_1 mar $1.000,00 $1.000,00 1 example_1 apr $0,00 $0,00 1 example_1 may $0,00 $0,00 1 example_1 jun $0,00 $0,00 1 example_1 jul $0,00 $0,00 1 example_1 aug $0,00 $0,00 1 example_1 sep $1.000,00 $0,00 1 example_1 oct $0,00 $0,00 1 example_1 nov $0,00 $0,00 1 example_1 dic $1.000,00 $2.000,00 Because I need a chart like this: Been the bars the planified amount and the line the real amount. I don't know if this is the best way to achieve this but is the only thing I cant think of. I need a little help.
