how to get the value for the previous non blank date
im trying to find previuos day price for stocks so that i can calculate Day on Day change. the problem is stock market is not open everyday and in this case some days will be blank when i calculate previous day price . im using the following measure to get previous day stock price: previous day price = CALCULATE(SUM('stocks data'[Close]), PREVIOUSDAY('stocks data'[Date])) this is a screenshot of the measure results: expected result: any idea on how to fix the measure to calculate previous stock price based on the last non blank date
Rolling Totals for the last month without Date context
I am trying to get the 12 month Rolling Total Amount to show in a table where I dont have the date in the row context I have State or city dimention as row context I just need the rolling totals for the last month i.e. Nov 2021 to Oct 2022 I need the sum of the total amounts for the last 12 months as one of the columns in the table below (column 6) irrespective of whatever date filters / slicers are picked can someone please help with this
