YTD calculated grouped by category showing blank when there is no data in table for selected month
Hi, I'm working on simple budget vs actual report in Power BI for each head of account and it uses Month & Year as filter to view the data. I have a calculated column for YTD ( say Actual_YTD) to calculate total sum from beginning of year to selected month/year. This Actual_YTD works for all cases except when there is no actuals exist for specific account in source table for selected month/year.
Summary of Issue : I would like YTD field to return a value even when there is no data exist for particular selected month.
Hi Dale, Below is screenshot of my sample data . Please note Table A has no data for 5/1 . In my Power BI, I have a date filter (dimDate joined to both Table A and Table B) to show combined view. When user selects month 5/1/2018, I expect YTD to be $4400 , whereas currently my visual displays a blank value. Hope this helps.