Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
10 | |
10 | |
10 | |
10 |
User | Count |
---|---|
19 | |
14 | |
13 | |
11 | |
8 |