Forum Discussion

somnath6309's avatar
somnath6309
Icon for Helper I rankHelper I
1 year ago
Solved

Reporting in Slowly Chaning Dimensions

Hi, Some times we have to do reporting with slowly Changing Dimensions. Assume, "Sales Managers" based on Customer's Continent get changed over years and there is a requirement to prepare the follow...
Need Help
Show and Tell
Tips and Tricks
  • somnath6309's avatar
    somnath6309
    1 year ago

    Hi, DataNinja777 
    Thanks for your help. However, I am not very familier with M Code and hence will request you to attach a sample file ( however, figures are not required to be matched) so that we can understand how to use the codes. 

     

    Moreover, pls use some lines to explain the following in some details:

    01. what is the use of the "original" key word ? what does it mean to use it here?

    02. Add2007, Add2008, Combined : these are variables, right ?

    03. Pls let us know about Table.Combine command and use of Parentheses "()" and Curlybraces "{}" together. 

    04. Pls give us some information about the "each" keyword in MCode. When it is to be used ?

     

    However, will request you to pls let us know how did you learned M Code ? Can you pls share some tutotial links here ?

    Thanks and Regards,

    Somnath6309

     

somnath6309's avatar
somnath6309
Icon for Helper I rankHelper I
1 year ago

Hi, DataNinja777 
Thanks for your help. However, I am not very familier with M Code and hence will request you to attach a sample file ( however, figures are not required to be matched) so that we can understand how to use the codes. 

 

Moreover, pls use some lines to explain the following in some details:

01. what is the use of the "original" key word ? what does it mean to use it here?

02. Add2007, Add2008, Combined : these are variables, right ?

03. Pls let us know about Table.Combine command and use of Parentheses "()" and Curlybraces "{}" together. 

04. Pls give us some information about the "each" keyword in MCode. When it is to be used ?

 

However, will request you to pls let us know how did you learned M Code ? Can you pls share some tutotial links here ?

Thanks and Regards,

Somnath6309