Is there a similair like as in SQL a Where statement?
I try to say it as clear as possible.
I want to calculate the following in a pivottable:
ORPlease Login or Register to view this content.
Please Login or Register to view this content.
Is there a similair like as in SQL a Where statement?
I try to say it as clear as possible.
I want to calculate the following in a pivottable:
ORPlease Login or Register to view this content.
Please Login or Register to view this content.
COUNTIF and SUMIF are the closest match, for the examples you list.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Those are not available is a pivot table measure.
Thats the whole problem. I want to show data, with a pivot table, but i dont know how to formulate formulas for a powerpivot, which shows me the stated in my first post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks