Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
Dear All,
I need to produce two columns, A & B.
In column A : I need to count rows from 1 till 7 and the restart the counter in next row just as in the visual below until the end of the paticular stock eg AAPL.
In column B : I need to give a consecutive unique ID per group of 7 eg. AAPL1 ... AAPL2 ... AAPL3 ...
Would need to create this using calculated columns, i have been trying for hours whithout any luck.
Thnak you for any possible help
Solved! Go to Solution.
@Anonymous , create a new column like
New column = "APPL" & (Quotient([countrows test] -1,7) +1 )
Hi @Anonymous 👋
Can you explain how you generated the "Countrows test" column in the first place ? I need a similar field to create an id identifying which data came before which.
Many thanks and have a great day, 🙂
Hi,
Paste data in a format that can be taken to an MS Excel file. Also, against which number of column A do you want see AAPL1 or AAPL2 - should it be against 1 or 7?
Can you please do such calculations in Power Query, not in DAX? Power Query is the right place for this. In DAX it's possible but will be 1) ugly and 2) slow.
@Anonymous , create a new column like
New column = "APPL" & (Quotient([countrows test] -1,7) +1 )
Hi,
How about doing somting like the following:
Dividing the cycle length into 4 pieces each piece has 2 rows (Dates). Then take the sum of the change column and avarege it out. How would you implement something along those line?
THanks for any help
Hi Amitchandak,
Uuff!!! Thank you very much for the reply, supper easy solution. I was able to create both needed column with your Dax formula.
Million thanks,
Kr
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
91 | |
86 | |
83 | |
76 | |
49 |
User | Count |
---|---|
145 | |
140 | |
109 | |
68 | |
55 |