Absolutely, there is enough formatting and layout flexibility in SSRS to arrange the pixels any way you desire. Can you show a preview of the data and the current report...

Alternate way. Use the existing date dimension table as an intermediary which should eliminate all conversions. Sorry to be thinking out loud here....

--Staging table in ETL process
DROP...

Computed persistent column idea. Renaming tables to Staging and Fact to better represent the actual use case.

--Staging table in ETL process
DROP TABLE IF EXISTS #Staging; 
CREATE TABLE...

My exposure to data virtualization limited but it seems to be a buzzword. So something for you to consider. The tool I used had drivers for various sources and allowed...

• This reply was modified 1 year, 9 months ago by  Chrissy321.

This author in the comments seems to indicate that the two methods are equivalent.

https://chris.koester.io/index.php/2017/06/21/process-ssas-tabular-tables-partitions-tmsl/

This documentation suggest starting with a Clearvalues.

https://learn.microsoft.com/en-us/analysis-services/tmsl/sequence-command-tmsl?view=asallproducts-allversions

So my current method is to Refresh-Clearvalues...

• This reply was modified 1 year, 9 months ago by  Chrissy321.

There are some 3rd party 'file watcher' components for SSIS. Not worth it on many levels. https://andyleonard.blog/2017/11/ssis-design-patterns-sniffer-file-watcher/

Like Jeff says poll as frequently as needed, log file found situations,...

Yes I have...

Does this help?

Provide the table structure of table ing if you want help inserting into it.

;WITH ctevalues AS 
(
SELECT 
'pasta pollo' AS recp_name, 
'paprika' ing_name,
'1' AS qty
)
--Provide...

I went forward with the "Convert to float method with rounding to 6 (significant figures)" method above. It matches the Excel calc,  avoids arithmetic overflow errors,  produces output with enough...

I am evaluating the below methods with my full data set. Now 'rounding' to 6. The excel formula uses the excel power function with the caret symbol and matches the...

Yes it's a simplified rate of return function but not the more formalized IRR function which Excel has and others have done in tsql. Appreciate the help and will follow...

'Correct' answer for a negative.

--Excel thinks the correct answer is -20
SELECT 
POWER(
CONVERT(FLOAT,80.00/102.93),
CONVERT(FLOAT,365/COALESCE((NULLIF(DATEDIFF(d,GETDATE(),'2023-12-31'),0)),365))
) - 1

--An invalid floating point operation occurred.
SELECT ROUND(T.C, 2 - FLOOR(LOG10(T.C)))
FROM
(SELECT
POWER
(
CONVERT(FLOAT,80.00/102.93),
CONVERT(FLOAT,365/COALESCE((NULLIF(DATEDIFF(d,GETDATE(),'2023-12-31'),0)),365))
) - 1 C) T;

Thanks all. I am replicating an Excel formula translated into SQL by a business analyst. They refer to it as rate of return. Seems to provide the 'correct' values but...

I suspect you are returning a duplicate columns. Do not use SELECT * except for testing, ad hoc types of queries. List all your columns explicitly.

The create table statements is a technique to generate sample data for the purpose of demonstrating the select query in the dataset. Typically the dataset select query will query directly...