cancel
Showing results for 
Search instead for 
Did you mean: 

Dyanamic Dimension from measure in power bi

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.
 
Need to show in Matrix
Row = State, City 
Column = Bucket
Value = Distinct Count of CustID
 
Dyanamic Dimension
 
Status: Needs Info
Comments
Moderator

@Vikram1,

Please share sample data of your table and post expected result based on the sample data here.

How to Get Your Question Answered Quickly


Regards,
Lydia

Moderator
Status changed to: Needs Info
 
Frequent Visitor

please send your email id so i can send excel file with code and requirement detail. here i am not able to attach

Frequent Visitor

My Email ID is vikram.jain@bitscape.com

 

Frequent Visitor

Please Find Input output Detail of my Issue "Dyanamic Dimension from measure in Power BI "

https://www.dropbox.com/s/n8hrbv6sncgnquk/Copy%20of%20Issue%20Dynamic%20dimension.xls?dl=0

 

Thanks

Vikram