Dear Andy amazing video. You do standard 1 hour video in 15 minutes. Great Job. it took totally 3-4 hour for me to watch over and over and do by myself))). İt really helpful.
I really like these suggestions and you have some clean formulas for the PY and CY figures. Do you have any suggestions on similar formulas for MTD compared to PY and Previous Month? For example if you were looking at this month, you don't want to compare all of July 2022 to only 4 days worth of July in 2023, and at the same time, you don't want to compare all of June 2023 to only 4 days of July 2023.
how do i dynamically change colors for a KPI that's a single value like average rating? Like a card with a single value 4.5. Change color based on whether it's under 4 or above 4.
These are really useful! Thanks Andy. Question - I'm trying to do the same thing with creating measures like CY and PY but instead using CY and Targets. However these are in different sources, on monthly level only and always create problems with trying to put it in the same chart to show any of the KPIs. Do you have any suggestions?
How to modify this Current Year Total to exclude months that are not complete in 2024? For PY I would like to compare only the months that are complete. Can you please guide?
I came across your video for the first time. I see that you are selling your Dataset so if we don't buy it, we can't follow your steps to create these KPI's. Correct?
Hey Andy, thanks for the great tutorial! Can I ask how you maintain the same KPI numbers in sheets 2, 3, etc.? I duplicate the first sheet and try to insert the sparkline, but as soon as I drag the purchase date in columns and the CY Sales in rows, the KPI numbers are changed and they show "Sales from ... to ...", instead of 130,388,128 as shown in yours. I also tried to reapply them manually by editing the title, but I still get different numbers
Andy, nice walk-through. Your current measures are fixed to the max year of your model's calendar. How do you get PY to be dynamic? In other words, if I add a year slicer, how do I get PY to change based on my slicer's selection?
Is it possible to swap the two measures based on two filters selection. There are two filters A and B, there are two measures sales and profit. If I select one value or more than 1 value in the A filter then it should take sales If I select one value or more than 1 value in B filter then it should take profit User Will select one value or multiple selection in the filter
Hi Andy another amazing learning video as always from you,Thank you so much!! Just want to know could please guide how can we create the YoY quarterly sales as well. Waiting for you reply🙂
Thank you Andy, I really appreciate it. What change can i make to the formula to return the last 12 month CY and PY.. eg Apr 2022 to Mar 2023. Instead of Jan to Dec as shown. Thank you for your help.