Help with a row values

[alfredorhz]

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

[vojtechsima · Accepted solution]

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.

[alfredorhz · Accepted solution]

Hi @vojtechsima 

Thank you
here is the example file
Sample_File_With_data table.pbix 

[alfredorhz]

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

...

[vojtechsima · Accepted solution]

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.

[alfredorhz]

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

[vojtechsima]

@alfredorhz 
Glad to help.

[alfredorhz]

Hi @vojtechsima 

Can I Consult something more?
Your cycle data table is in this form

But my table has in that form, Cycle column has months, and every column in my table is a month too, Do you have any clue how I can do the same calculation?

I appreciate your words

[vojtechsima]

Hi, @alfredorhz 
I am not much wiser from the reply, could you please attach your file (obviously with public data).
Or just create mockup file so I have the needed strange with random data.
Post in for example on Google Drive or OneDrive and send me link here please.

[alfredorhz · Accepted solution]

Hi @vojtechsima 

Thank you
here is the example file
Sample_File_With_data table.pbix 

[vojtechsima · Accepted solution]

@alfredorhz 
I feel like we're running in circle, just unpivot your months in Power Query as in this file.

[alfredorhz]

Thank you @vojtechsima , you rocks

[vojtechsima]

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