Summing by date without adding the date to the table

Question

Hello all,&nbsp;I have 3 columns in my table.&nbsp;Search Terms&nbsp; &nbsp; &nbsp;Click&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;PlacementFace Mask&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Search PageHead Mask&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Product Detail Page&nbsp;When I Add a Date to this Table&nbsp; &nbsp; &nbsp;Date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Search Terms&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Click&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Placement01/28/2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Face Mask&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Search Page01/29/2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Face Mask&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Product Detail Page&nbsp;I want to be able to collect clicks according to the placements I want to do, for example, I want to calculate how many clicks on the word face mask come from the search page and how many product detail pages, and I want to do this without adding a date to my table.&nbsp;By the way I created Placement column with dax formula.

amitchandak · Answer

Headline , what is the issue with table1 without date, information seems to be correct

Forum Discussion

Summing by date without adding the date to the table

1 Reply

Related content

Adding columns

Running sum

Filtering a Sum

Improper Sum with slicer

Adding a column