Forum Discussion
Anonymous
7 years agoNot applicable
Calculating % of Month Complete
Trying to project some figures based on where we are in the current month. For example, we sold 10 units through the first 25% of the month, we're on pace for 40 units. I was able to do this orig...
v-frfei-msft
Community Support
7 years agoHi Anonymous ,
I suggest to use MAXX instead of LASTDATE. Please refer to this case.
https://community.powerbi.com/t5/Desktop/FIRSTDATE-and-LASTDATE-functions-broken/td-p/417927