I am trying to calculate my balance exposure as of a random date between the start and end date. Let me know if you help me in this
1. I need to create a date dimension so thatIcan pick any date and say how much is the balance of that day
if I pick 9/1/2016 my exposure is - 300+500
2. I also a need a financial year exposure.Filter all rows with exposure in the year 2016 ( slicer by any year).In this case, the rows will be 3,4,5 as the start and end year can be in 2016 ...
3. Using the slicer( date dimension), I want to select all rows where the eg Like start date > date dimension -30 days or end date < date dimension +30 days
Any thoughts .Thanks for your help
Create below measure. Dim is a calendar table which used as date dimension for users to pick up any date.
Sum balance =
SUM ( 'time period'[ Balance] ),
'time period'[Start Date] <= MAXX ( ALLSELECTED ( dim[Date] ), 'dim'[Date] ),
'time period'[ End Date] >= MAXX ( ALLSELECTED ( dim[Date] ), 'dim'[Date] )
Thanks it helps but i am still running into few issues.
If i pick a range of date in "Dim" , how do i identify all the rows in "timeperiod" which fall in the range and get a sum of balance.
The exposure could be as of a day or for a range of days
Read the announcement for more information!
We're rolling out new Kudos Given badges. Find out how many Kudos you've given.
Find out where you can attend!