Forum Discussion

priyankamane's avatar
priyankamane
Icon for Advocate II rankAdvocate II
9 years ago

dax calculations

Hi All,   Need help in Data Analytics Calculations. Currently, I am getting historical data for consumption as follows:   Date                    Reading(gallons)        Meter ID 10 Jan  2016  ...
Need Help
priyankamane's avatar
priyankamane
Icon for Advocate II rankAdvocate II
9 years ago

v-huizhn-msft

 

Sorry, my mistake in no. of days calculation, insted of 38, it should be 66 (with feb month days also) as it is calculated as per thle last reading date to current reading date. this is just an example. but formula will be same to calculate it. 

v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi priyankamane,

Is there any chance to list your expected result again? So I can provide the solution which is close to your requirement.

Best Regards,
Angelia