Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello everyone,
I need to calculate a formula taking into account data from the second row.
I show you an example in excel:
I have a filter in Power BI by date, which will select the numbers. Then I must apply that formula from the second row.
This means: data must be selected from the next day the filter was selected. In the example above, the user would select in the date slicer from 7 to 14 of May, so data must be calculated from 8 to 14th of May.
I calculated an index column in Power Query. And a "first row" measure which selects the index for the first row:
Solved! Go to Solution.
I loaded your excel data into a table called Second, and made a table visual and this measure, and put it on a card.
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
I loaded your excel data into a table called Second, and made a table visual and this measure, and put it on a card.
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Thank you so much @mahoneypat !!
I was really complicating myself with collumns and so on... It works wonderfully!! Thanks again!
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
25 | |
19 | |
18 | |
18 | |
15 |
User | Count |
---|---|
38 | |
22 | |
18 | |
15 | |
11 |