Combine selected value (slicer) with sum for selected period and previous period
Hi, I´m wondering if is possible to combine in one matrix these calculated values. I need something like this: I will be OK with this format too: visual is affected with this slicer: I try to use two measure in one matrix. The first one is: Sum Annualized Booking Value (Selected Year Marker) = VAR SelectedYear = SWITCH( SELECTEDVALUE(general_date_table[Year Marker]), "YTD Marker", YEAR(TODAY()), "1 Year Ago", YEAR(TODAY()) - 1, "2 Years Ago", YEAR(TODAY()) - 2, "3 Years Ago", YEAR(TODAY()) - 3, BLANK() ) RETURN CALCULATE( [Sum Total Contract Value], USERELATIONSHIP(contract_item_history[contract_revision_approved_date], general_date_table[Date]), YEAR(contract_item_history[contract_revision_approved_date]) = SelectedYear ) works perfectly the secont one, doesn´t work with the slicer: _test_Sum Annualized TCV = VAR year_ago = CALCULATE( [Sum Total Contract Value], FILTER( contract_item_history, YEAR(contract_item_history[contract_revision_approved_date]) = YEAR(TODAY()) - 1 ) ) VAR two_years_ago = CALCULATE( [Sum Total Contract Value], FILTER( contract_item_history, YEAR(contract_item_history[contract_revision_approved_date]) = YEAR(TODAY()) - 2 ) ) VAR three_years_ago = CALCULATE( [Sum Total Contract Value], FILTER( contract_item_history, YEAR(contract_item_history[contract_revision_approved_date]) = YEAR(TODAY()) - 3 ) ) VAR four_years_ago = CALCULATE( [Sum Total Contract Value], FILTER( contract_item_history, YEAR(contract_item_history[contract_revision_approved_date]) = YEAR(TODAY()) - 4 ) ) VAR _selected_year = SELECTEDVALUE(general_date_table[Year Marker]) RETURN SWITCH( TRUE(), _selected_year = "YTD Marker", year_ago, _selected_year = "1 Year Ago", two_years_ago, _selected_year = "2 Years Ago", three_years_ago, _selected_year = "3 Years Ago", four_years_ago, "N/A" ) I tried a simple one too, but doesn´t work neither: _test Sum for Previous Year = CALCULATE( [Sum Total Contract Value], FILTER( contract_item_history, YEAR(contract_item_history[contract_revision_approved_date]) = SWITCH( SELECTEDVALUE(general_date_table[Year Marker]), "YTD Marker", YEAR(TODAY()) - 1, "1 Year Ago", YEAR(TODAY()) - 2, "2 Years Ago", YEAR(TODAY()) - 3, "3 Years Ago", YEAR(TODAY()) - 4, BLANK() ) ) )<p><br />Any idea why is not working and how to fix it?<br /><br /></p><p> </p><p>Thanks a lot in advanced<br />Sona</p>
Previous Period Not Grabbing in Measure
Looking for any assistance - I have date periods set for a date slicer ie "Last 30 Days" I have created start of this period, end of this period, start of previous period, end of previous period measures so that I can ensure the report is seeing the dates correctly. Where my report hits is snag is when I want to do a caluclation on the previous period. IE order count Current Period gives me a caluation with the below measure: Count of Orders Current Period = CALCULATE([Count of Orders], DATESBETWEEN( Dim_Date[CalendarDate], 'My Measures'[Start of This Period],'My Measures'[End of this Period])) When I apply the same logic to previous period I get blank Count of Orders Previous Period = CALCULATE([Count of Orders], DATESBETWEEN( Dim_Date[CalendarDate], 'My Measures'[Start of Previous Period],'My Measures'[End of Previous Period])) Any assistance is appreciated!Choose data, display current week data as well as previous week
Hi Guys, based on a selected date (week) in a slicer (SlicerWeek), I want to display in a table the value of the week, as well as the previous week value. The columns of the table contain the date, formatted as week. There is a date table, linked to a fact table. In the screenshot you can see the desired result of the table, but I want to select only one week in the Week Slicer and display tow weeks data (there are other visuals that show only the current week value). Regards, Toddy
