Forum Discussion

jaweher899's avatar
jaweher899
Impactful Individual
3 years ago

Dynamic column names in field parameter

I've the following pbix file https://1drv.ms/u/s!Amd7BXzYs7AVk3D5iDMIrhfnpQNW?e=lHWRuH

 

The data model is simple 

one fact related to date table and field parameter table

 

I need to create a dynamic column names, concatenate the month periode selected by the field parameter 

 

 

 

 

I do it manually, I duplicate the same script for months june and march and I should do the same for all months 

Parameter = {
    ("Month Name June-2022", NAMEOF('DimDate'[Month Name]), 0,"June-2022","Month Name"),
    ("sales.Reason June-2022", NAMEOF('FactSales'[sales.Reason]), 1,"June-2022","sales.Reason"),
    ("Customer.Email March-2022", NAMEOF('FactSales'[Customer.Email]), 2,"June-2022","Customer.Email"), ("Month Name May-2022", NAMEOF('DimDate'[Month Name]), 0,"March-2022","Month Name"),
    ("sales.Reason March-2022", NAMEOF('FactSales'[sales.Reason]), 1,"March-2022","sales.Reason"),
    ("Customer.Email March-2022", NAMEOF('FactSales'[Customer.Email]), 2,"March-2022","Customer.Email")
}
 
Is there a way to do it dynamically please?

 

Need Help