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

       




      • vojtechsima's avatar
        vojtechsima
        Super User
        3 years ago

        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.