Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Site Type Period Account Amount
BD1 ANF 2022-09-15 Thujan 4
BD1 ANF 2022-09-16 Thujan 4
BD1 ANF 2022-09-15 Factor 0.3
BD1 ANF 2022-09-16 Factor 0.3
BD1 ANF 2022-09-15 Slippery 1.2
BD1 ANF 2022-09-16 Slippery 1.2
i want to create a new column with sum of values by account,
I've tried this formula but it doesn't work
Amount THujan = CALCULATE([Amount], SS_Account="Thujan")
is there any other way?
Solved! Go to Solution.
Hi,
you could use the below code for creating the column :
Appreciate your Kudos and please mark it as a solution if it helps you
try to add a new column with the code below:
Hi,
you could use the below code for creating the column :
Appreciate your Kudos and please mark it as a solution if it helps you
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
126 | |
78 | |
78 | |
59 | |
51 |
User | Count |
---|---|
164 | |
84 | |
68 | |
68 | |
58 |