Forum Discussion

alfredorhz's avatar
alfredorhz
Helper I
3 years ago
Solved

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( ...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
alfredorhz's avatar
alfredorhz
Helper I
3 years ago

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's avatar
vojtechsima
Super User
3 years ago

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's avatar
    alfredorhz
    Helper I
    3 years ago

    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

      • alfredorhz's avatar
        alfredorhz
        Helper I
        3 years ago

        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