2025 Feb 06 5:27 PM - edited 2025 Feb 10 7:21 AM
Hi experts!
I´ve data model on daily granularity.
What´s the easiest and most performant way to achieve this?
Here is my (sample) model:
Story with sample data:
As you can see for data on Feb 10th and 23rd the price from Jan instead of Feb is taken
Here is the data action to calculate AMOUNT:
Reason for the wrong calculation is the FIRST function, which returns the first day of the year only. Not aware of a function which returns the first day of the month.
However, AMOUNT should be calculated on daily level as QUANTITY (daily level) x PRICE (monthly level).
If possible I´d like to avoid a FOREACH loop because of data volume and performance. Any ideas to achive this?
Thank you,
Thomas
Request clarification before answering.
User | Count |
---|---|
60 | |
8 | |
7 | |
6 | |
6 | |
4 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.