Forum Discussion
alfredorhz
3 years agoHelper I
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( ...
- 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. - 3 years ago
Hi vojtechsima
Thank you
here is the example file
Sample_File_With_data table.pbix - 3 years ago
alfredorhz
I feel like we're running in circle, just unpivot your months in Power Query as in this file.
vojtechsima
3 years agoSuper User
alfredorhz
I feel like we're running in circle, just unpivot your months in Power Query as in this file.
alfredorhz
3 years agoHelper I
Thank you vojtechsima , you rocks