Forum Discussion
Help with a row values
Hi Power Bi, Community, I hope everyone doing well
I need some help to get a row values and divide a single colum value for a constant value with this example, always working with a previous month( Year_Month), Could you please help me?
for exmaple
Colum = Cycle
ROW SEP = for echa colum value in the row ("Jan", "Feb"....."Nov","Dec") / constant value
Hi, alfredorhz
I believe I did precisely what you asked for.
Let's say constant value is 11.5
So I divided each month by value in the month in cycle row by 11.5.
If the value is 0, it's gonna be 0, tha's why it doesn'T show.
Please check again or give me sample data with exact result so I can match it precisely.Hi vojtechsima
Thank you
here is the example file
Sample_File_With_data table.pbixalfredorhz
I feel like we're running in circle, just unpivot your months in Power Query as in this file.
10 Replies
Hi, alfredorhz ,
you can try this, three measures, but I am not sure if I can get what you want. Here's my pbix file.Value Sum = SUM(Cycle[Value]) Constant Value for Month = CALCULATE( [Value Sum], ALLSELECTED(Cycle[Date]) ) Division = DIVIDE([Value Sum], [Constant Value for Month])Hi vojtechsima
Thank you for your help, your answer help me with another part of this table, but may be I don´t explaint in a correct form, I hope this helps to understand what I looking for.
I need to divide for a constant each value in a cycle row for example:
Clycle Sept, fon each month colum value divide for a constant
Cycle Sept Row= Jan value = (2/11.5), Feb(12/11.5)-..... Dec(5/11.5)
Cycle Oct Row =Jan value = (2/11.5), Feb(12/11.5)-..... Dec(7/11.5)
.......
Hi, alfredorhz
I believe I did precisely what you asked for.
Let's say constant value is 11.5
So I divided each month by value in the month in cycle row by 11.5.
If the value is 0, it's gonna be 0, tha's why it doesn'T show.
Please check again or give me sample data with exact result so I can match it precisely.Hi, vojtechsima
Yes, you are all right, I put the constant value here....
Constant Value for Month = CALCULATE( [Value Sum], ALLSELECTED(Cycle[Date]) )thank you so much