Forum Discussion
Solved
YTD performance
Hi All I'm trying to replicate a calculation I have in excel into Power BI. Long story short, I have a table which display what the performance is for each month (see screen shots) and a second...
RodrigoTXRAHere is something I put together to give you an idea, logically you should have a FIscal Date DImension in model for time intelligence and this kind of calculation, but I guess this will get you started.
Cheers!!!
P
RodrigoTXRAHere is something I put together to give you an idea, logically you should have a FIscal Date DImension in model for time intelligence and this kind of calculation, but I guess this will get you started.
Cheers!!!
P
parry2k unbelievable, fantastic solution. It indeed worked for me. I required to make some changes as my Month column was displaying the date type as text for the month description, so i just went back to the original settings and it worked well.