DAX/Measure Support

[rgpsathish]

Hi Experts,

Need expertices support for below querry, currently i am link the Sharepoint list to Excel table then create some additional columns in Excel table and again creating new table for calculating the sum then linked the both tables to Power BI dashboard.

Instead of creating multible tables in Excel, is there any solution for creating measure or something in DAX functions.

[rgpsathish]

Thanks @xifeng_L  for your quick support.

[rgpsathish]

Hi @xifeng_L ,

i am getting below error while execute. whether all columns should be values.

[xifeng_L]

You need to make sure that the Start ID and End ID columns both have values in order to do so.

Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

Thank you~

[xifeng_L · Accepted solution]

Hi @rgpsathish ,

You can refer below demo.

Demo - DAX Or Measure Support.pbix

Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

Thank you~