Month First data and Last Date Value for snapshot fact table

sangeeth8787 — Thu, 10 Jan 2019 10:13:47 GMT

Hi,

I have two filter one with date and month, and a snapshot fact table, If user select a particular date, then I want to show the balance of starting and end of the day values, If I choose any particular date in filter criteria, the correct values are showing up, but when I choose month filter, the values are summing up. But the required output is like

Month Date OpeningBalance Closing Balance

Jan 1st Jan 15.5 26.5

Jan 2ndJan 26.5 55.5

Jan 31st 105 215

If a user choose filter Month then desired output is 1st Data of January Opening Balance (15.5) and Last Date of January which is 31st Day Closing Balance (215)

If a user choose any particular date only, like Jan 2nd the opening balance 26.5 and closing balance 55.5.

Could you please help with this query.

Many Thanks

Sangeeth

topic Month First data and Last Date Value for snapshot fact table in App Development

Month First data and Last Date Value for snapshot fact table