Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Creating Calculated Table help

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

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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..

Brenden_1-1694611103491.png

 

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

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

Brenden_0-1694610881514.png


How can I get these functions to work?

Anonymous
Not applicable

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..

Brenden_1-1694611103491.png

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors