Jay Scott

1. Community
2. Frontend, Designer and Consumer
3. InMemory Measure to calculate daily sales in a period

I created a cube for DIM_JournalPeriod to place the measure.  The only shared Dimensions in the cube is the date dimensions from DIM_JournalPeriod.  Dim_JournalPeriod is linked to Budget Sales by T...

• View comment
• Created December 03, 2021 15:24
• 0 votes

1. Community
2. Frontend, Designer and Consumer
3. InMemory Measure to calculate daily sales in a period

This was an important hurdle we had to overcome in order to calculate the budgeted sales per day.  We needed working days.  So we created a measure the Data Model calculating working days such as: ...

• View comment
• Created December 01, 2021 21:27
• 0 votes