Forum Discussion

Diego-mx's avatar
Diego-mx
Advocate I
8 years ago
Solved

Calculated Tables with M language

Hello,  I recently started using PowerBI.  I come from R and I have found the modelling capabilities very nice.   In this occasion, I want to  create Calculated Tables using R scripts.  Either that...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    Create your Cars query. Create another query that references that query. You can then insert an R script step into your second query.

  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi Diego-mx,

     

    It would be easy like below. Then you can apply R after that.

    let
    Source = DimProduct
in
    Source

    Calculated_Tables_with_M_language

     

    Best Regards,

    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi Diego-mx,

 

It would be easy like below. Then you can apply R after that.

let
    Source = DimProduct
in
    Source

Calculated_Tables_with_M_language

 

Best Regards,

Dale

Diego-mx's avatar
Diego-mx
Advocate I
8 years ago

Thanks.  That wasn't that hard.  =) 

Actually, I feel too much of a newbie with such simple solution, ha.