Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

DAX Formulas transform Power Query M Formulas

Hi There,   I have added a column with DAX formulas on front side in Power BI desktop like this:   Last Choice= VAR _lastIndex = CALCULATE( MAX( 'answers'[_id] ), ALLEXCEPT( 'answers...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi StefanoGrimaldi 

 

Thank you for your response but I need actually a new column. If you say me how can I add a new column in Power Query ediyor, that's enough for me. I try to explain what I need below:

 

I have a table like this:

 

 

 

 

 

 

 

 

 

 

 

 

I need a Last Choice column Like this table:

 

 

 

 

 

 

 

 

 

 

 

 

I dont have date for this. We can sort this data only for id. I dan do it in DAX but I need it in power query.

 

I hope It can be done.

 

Best,