Forum Discussion
Need some DAX code assistance please!
mdykes ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.
Hi Amit, I hope this may help clarify.
Query 1 is a query containg the tables in the Example. Query 2 is a query containing different information. Currently, the Machine Hour reading table (Screenshot below) is a Measure that is visible in the visualisations tab of Power Bi and contains an Hour reading corresponding to the Machine with a date acting as a filter. This allows me to sum a reading based on a filtered date and corresponding Machine.
The code for this Sum calc for the Hours is below, date filter created with relationship
Hour Total = SUMX(VALUES('XXXXX Vehicle Information'[machine]),[Hour total calc]) ---> 'Measure'
The outcome required is a mulitplication of the Fuel consumption rate column and the Machine Hour reading 'Measure' to create a Fuel used column filtered by a date. This would give a summed value. Would this be a measure?