Creating Calculated Table help

[Brenden]

I am trying to create a (calculated?) table that will provide the following:

Column1 = yesterday's date (truncated)

Column2 = COUNTROWS (from another existing table in my report/dataset)

I'm seeing documentation but not anything that helps me understand how to write this in DAX, defining each column as needed.

Desired result:

ReportDate, Volume
09/11/2023, 132

My plan is to use PowerAutomate to refresh this report, then export this table to .csv and save to Sharepoint, then add that Sharepoint as a data source back to the report so I can keep a running 7-day total of volume each day.

Ultimately it will look like this,
ReportDate, Volume
09/05/2023, 90
09/06/2023, 103
09/07/2023, 98
09/08/2023, 110
09/09/2023, 122
09/10/2023, 96
09/11/2023, 132

[Brenden]

I tried another way, but no luck. At least this shows clearly what I am trying to do. Any ideas?

How can I get these functions to work?

[Brenden · Accepted solution]

I'm not sure why my previous attempt doesn't work. I was able to get it by doing "New column" and adding the functions that way. I don't see anything in the documentation that explains why it must be done this way..