Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in BI by (11.1k points)

I am a table 

Month, CustomerId, ProductId, TotalQuantity
Jan,1, CAR,
Feb,1, CAR,

So I want to add sales into it

I add wd the column with the following formula

=SUMIFS(Sales[Quantity],Sales[CustomerId],[@[CustomerId]])

What is the use of @ from the above formula? 

1 Answer

0 votes
by (22.5k points)

Use the following Measures

TotalQuantity = CALCULATE(SUM(Sales[Quantity]), FILTER(Sales, Sales[CustomerId] = EARLIER (Sales[CustomerId])))

Want to learn more about Power BI? Check out today: Power BI course 

Related questions

0 votes
1 answer
asked Dec 24, 2020 in BI by Chris (11.1k points)
0 votes
1 answer
asked Mar 2, 2021 in BI by Chris (11.1k points)
0 votes
1 answer
asked Dec 3, 2020 in BI by Chris (11.1k points)

Browse Categories

...