Forum Discussion
Calculation - % Complete YTD
Hi, I need some help to create a measure that gives me a YTD % by month. I've shown the data as I would do it in Excel, but I'm not sure what I need to include in my measure in Power BI. I h...
Hi Anonymous ,
That's possible but you will need to use the CALCULATE function, and this will result in much more measures. And be aware of the filter context in this case.
Regards,
Mauricio
Thanks for the quick response. Is there a solution that would let me keep the data as I have it in one sheet? I have other calculations running off that sheet that I would prefer not to duplicate.
Hi Anonymous ,
That's possible but you will need to use the CALCULATE function, and this will result in much more measures. And be aware of the filter context in this case.
Regards,
Mauricio