topic Re: DAX/Measure Support in DAX Commands and Tips

DAX/Measure Support

rgpsathish — Wed, 15 May 2024 04:13:24 GMT

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.

Re: DAX/Measure Support

xifeng_L — Wed, 15 May 2024 08:42:02 GMT

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~

Re: DAX/Measure Support

rgpsathish — Thu, 16 May 2024 05:11:56 GMT

Hi xifeng_L ,

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

Re: DAX/Measure Support

xifeng_L — Thu, 16 May 2024 05:50:53 GMT

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~

Re: DAX/Measure Support

rgpsathish — Thu, 16 May 2024 07:44:45 GMT

Thanks xifeng_L for your quick support.