No worries 🙂

To answer your question: Yes there is. For SSAS Tabular and Power BI, you could use DAX Studio which is freeware. You should also be able to run...

You'll need to use an iterator like SUMX to force the calculation over the individual rows. What does your DAX formula look like right now (assuming that you're using Tabular).

I know Power BI Desktop allows you to create parameters which you could then change the values of after deployment. Haven't played around with it extensively, but you should be...

You can use parameters for the components of your connection, which should allow you to change values after (or at deployment).

Yes, using Excel (or Power Pivot for that matter) just to get to a CSV will not be a good solution...not at the data volumes you're looking at.

Report Builder could...

It's whatever key you defined for that specific attribute, and it has to be a single column.

It's a tricky situation. SSAS provides the semantic layer you want, but if your goal is to provide granular-level data in a csv format then you would either have to...

Ok...let's try again. Interesting requirements.

Here's my two cents based on what you've described:

In theory an Analysis Services cube (multidimensional) in ROLAP mode (or a Tabular cube in Direct Query mode)...

Interesting requirements 🙂

Here's my two cents based on what you've described:

In theory an Analysis Services cube (multidimensional) in ROLAP mode (or a Tabular cube in Direct Query mode) will work...

I think you may be over-complicating the DAX formula. This works for me:

Rolling 12 Month Total = 
CALCULATE 
(
    [ReceivedAmount]
,   DATESINPERIOD
 ...

so I would try to split the updates into multiple parallel updates based on some column you could use for "partitioning" (using table locks to avoid a deadlock). Physical...

• This reply was modified 6 years, 5 months ago by Martin Schoombee.

Yes, there's a few things you can try.

I'd get rid of the Merge first, splitting inserts and updates into separate statements. It's clearly the Updates that are slowing things down...

Can you provide more information? A screenshot of the results as well as the monthly numbers and your model would be helpful.

This may help: http://radacad.com/datesinperiod-vs-datesbetween-dax-time-intelligence-for-power-bi

So it's really a set you want to create? If you need something to be dynamic, you'd probably have to create a calculated table and use DAX to populate it...