if I have a three Table 1. Dim_Customer : joiningDate, LeavingDate, State, District, Cust_Type, CustID, CustomerName 2. Dim_Date : All Possible Column like Date, Year, Month, Quarter etc.. 3. Fact_Sales : CustID, InvoiceDate, SalesAmt
need soluation like : when i select 3 months from slicer then i need to create column : (Fact_Sales[SalesAmt]/(Number_of_Month Selected)) and create bucket like 0-100, 100-200, 200-500 etc. Group by with CustomerName/CustID and Customer count in bucket which we have created.