The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have a situation where I need to calculate % increase or % decrease of number of manual uploads that are occurring in the current and previous week.
One more thing to add on is not only the latest weeks, but also if we select multiple from the last year weeks on the slicer.
For example in the uploaded picture I have selected the 47th and 48th weeks of year 2017. Over here the number of uploads are decreased so I need to calcilate the decrease %
Hi @charan85,
In order to help you better can you share a sample of you data?
Regards,
Mfelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @charan85,
Just to give you a better help if you select more than one week you want to calculate the difference between the 1st and last week or the difference between 1st to 2nd + difference 2nd to 3rd and so on..
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português