Start from second row in column

Anonymous — Thu, 11 Aug 2022 08:08:53 GMT

Hi,
I need to calculate theta angle in Power BI.
Like in Excel:

First row needs to be zero and the rest rows goes:

5163 needs to by dynamic based on data so i choose to get MAX value from added Index row in Power Query

So first row in power BI needs to be 0 and the rest needs to be based on previous value

I got 3 problems because:
1) I dont know how to set first value to 0 when I try to add new column
2) I cant use the function Earlier because in the first row it tries to get data from non existing row
3) Can you actually start function to work from second row ?

Re: Start from second row in column

lbendlin — Sun, 14 Aug 2022 02:17:44 GMT

you have quite a few more problems:

1. You cannot dynamically add calculated columns. They are static.

2. EARLIER doesn't mean what you think it means (it means an earlier filter context)

3. Power BI has no idea what "second row" means. You need to indicate that in your data, for example by including an index column.

Please provide sanitized sample data that fully covers your issue. I can only help you with meaningful sample data.
Please paste the data into a table in your post or use one of the file services like OneDrive or Google Drive. Screenshots of your source data are not useful.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

topic Re: Start from second row in column in DAX Commands and Tips

Start from second row in column

Re: Start from second row in column