Displaying Data for every N Months (Every 3 Months , Every 12 Months)
The Use Case : The Slicer has 4 options to select data from : 1. Daily - Select Start and End Date in the slicer - Display the data based on the date Selection 2. Monthly - Select Start and End Date in the slicer - Display the data for All Month End Dates between the Range 3. 3 Months - Select Start and End Date in the slicer - Display the data for All Month End Dates between the Range BUT now the difference between the month end dates should be 3 Months and not 1 month. 4. 12 Months - Select Start and End Date in the slicer - Display the data for All Month End Dates between the Range BUT now the difference between the month end dates Should be 12 Months. For futher reference please find the attached screenshots of different output scenarios
Percentage of Total with Filter
Hi, I'm calculating % of total by calculating a new measure by this formula:- FY21 Q1 ACTUAL = DIVIDE(SUM('Page1'[Q1 FY21]),CALCULATE(SUM('Page1'[Q1 FY21]),ALLSELECTED('Page1'[Domain]))) But when i'm applying filters to the "domain/sub-group" then "FY21 Q1 ACTUAL" values are being changed. My goal is to keep the FY21 Q1 actual value as it is same even after applying "sub-group/domain" level filter in another sheet/table. . Please help me...
