Forum Discussion

Deem's avatar
Deem
Frequent Visitor
3 years ago
Solved

Life Cycle Calculation

Hi everyone,   I would like to get the following output in PowerBI. I've read a different post with a solved solution but unfortunately  I can't reproduce the solution without an error. I've asked ...
  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    3 years ago

    Hi , Deem 

    I download your .pbix file , For your problem, Here are my answers:

    (1)At present, the value you modified is correct, and you can return the correct table, where 2050 means that the year of the generation stops in 2050, and the deadline for the generation is not specified in your table, so you need to replace the value with 2050.

    (2)For the [life] field , you can edit the M language in  "Aangepaste kolom toegevoegd" step:

    = Table.AddColumn(#"Type gewijzigd", "Aangepast", (x)=> List.Generate(()=>x[endyear]+x[life],(y)=> y<=2050 , (y)=>y+x[life] )   )

     

    Best Regards,

    Aniya Zhang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

     

Deem's avatar
Deem
Frequent Visitor
3 years ago

Hi v-yueyunzh-msft,

 

Thank for your quick response. It looks great. Unfortunately I get a new column with function. And I can't open your Pbix because is searching for a Excelfile.

I will attach my original dataset in the opneing post.

 

 

 

v-yueyunzh-msft's avatar
v-yueyunzh-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi, Deem 

You can try to delete the "each" in the enter box :

 

Then you can get the list .

 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

 

 

  • Deem's avatar
    Deem
    Frequent Visitor
    3 years ago

    Hi v-yueyunzh-msft ,

     

    Sorry but removing each doesn't work. At the bottom of my original post I've added a Onedrive downloadlink of my pbix . Can you pleas have a look at it. Thanks.