Hello chandu , I am really excited to take excel course but due to price 247$ is very much high , can reduce for price for university students , hoping you could reply on these , and thanks for giving datasets for SQL sessions ,
I am very impressed, outstanding job on tis dashboard. Thank you for being you, and for your creative and intuitive insight in to telling stories with data!
Hi Chandoo. All your Trainings are Very interesting. You make a lot of effort to prepare them; which gives videos with good quality . You are using a very good and simple teaching. Thank you.
Hi Chandoo , i feel variance should be Calculated as Total_Target - Total_Actual because target is what needs to be acheived and actual is what has been achived.
In that case, you will get a positive variance when we do not meet the target. As positive numbers indicate good outcomes, the logic needs to be actual-target.
can we shrink the size of last visual which has months showing if target met or not having red and green colors...the column visual that you have put out there. if i shrink the width of it, few months are being hidden. any way dear Chandoo to still keep them showing...
Hi Chandoo, when am creating the visual for measure YTD actual, am getting card visual as " Blank ". Could you please help me with this? Hope the measure is right! : YTD sales actual = CALCULATE([Total sales actual], DATESYTD('Calendar'[Date]))
Hi Chandoo! When you choose an individual sales person at 20:40 you get Month Target Reached = 7, however the little chart below clearly shows smth different, besides above it says 'we met targets 2 out of 14 month. How could we fix that?
Hi, you can fix this issue by changing the bar/column charts to line charts. Line charts are perfectly filtering out data for individual salesperson. I am yet to figure out the reason.
I love how this video is challenging a beginner like me to figure out nuances instead of spoon feeding every step. I managed to solve most of my problems, but somehow months target reached is still 0 and my column chart for target vs actual sales shows no data for any of the in between months. Why?
Wonderful video but i have a question on i am unable to get the ytd sales actual, ytd variance, ytd variance % , ytd sales target. Please answer my question i am unable to proceed forward.
HI chandoo, in minute 8, YTD Sales Actual = CALCULATE([Total Sales Actual], DATESYTD('Calender'[Date]), this formula didnt work in my case? 'Total Sales Actual' didnt read by CALCULATE function. however it was working fine in previous formulas. Please help me with this. Thank you.
Hi Chandoo, thanks for the video, certain steps of the video have been removed, would have been better if those also were included. Anyways thanks for the video
Hi Chandooo Anna, I have reached till dax function - target for the month, but I am not getting any expected value, it results this _ _ and there are no errors in the formula. Can you please help me rectify this?
Hi Chandoo, I was your channel following for months now and your videos are very useful. How can we use measures in a new measure as in the above dashboard i can't add Variance when creating Months target reached measure. If you can reply it would be very helpful. Thanks.
Hello Chandoo Bruh , I have a query regrading Months Target Reached Formula , Variance didnt comes in option .will i create a Dax Calculation . Kindly Sort Out this
thank you so much for the content you have been posting on RUclips Channel. May I suggest/ask something? Can you please teach us how to create a multilanguage Dashboard in Power BI? I have been looking for something on Google, and RUclips and so far I couldn't find anything. Please, can you help me with this?
Hello, Chandoo Brother, you skip two formulas 1. YTD Variance 2. YTD Variance % during editing the video so I Can't understand it. Please tell me how can I calculate these formulas? Because I am beginner.
Hi Sir, I it’s helpful I learned lot from your video I would like to request your all data shows only about sales data if you can do some dashboard with supply chain and inventory management data it will be helpful for other professionals. It’s just request. Thank you 🙏🏻
Hi chandoo if I am calculate -- Variance = [Total Actual Sales] - Targets[Total Sales Target] how to get variance in Positive value that is Impossible because your Actual sales = $1,89,49,239 and Target is $1,93,16,100 and your variance % is also wrong.. Can you proved that
Hi Chandoo, YTD Sales Actual = CALCULATE([Total Sales Actual], DATESYTD('Calendar'[Date]), this formula didn't work in my case. 'Total Sales Actual' didn't read by CALCULATE function. however, it was working fine in previous formulas. Please help me with this. YTD Variance % is also showing -100%. Thank you.
Hello, I hope you are well. I am a student. I need help with the decision support system. I am looking for training in this subject. Is it a requirement to understand the ssis ssas ssrs program or Power Bi just to implement my graduation project?
Chandoo i had a doubt in the 'Month Target Reached' though i used the correct dax measure like you ,it results 14 but it's actually 2, please solve my issue anyone!
The number you see depends on the filter / evaluation context. Make sure you are not filtering something out and have used the dax as demoed in the video.
Hii sir if the data is load it's showing error in actual sales andria. Kimpton and this not allowed for columns on the one side of a many to one relationship or for columns that are used as the primary key of a table. Ani vasthundhi sir em cheyyali ippudu
Please create advanced level power bi financial dashboard for financial planning and analysis domain covering income tax statement, cash flow, variance and ratio analysis OR some banking detail dashboard covering total disbursement count, value and sanction count and value, total aum(asset under management), gross income, ltv%, bounce rate,ROI%
when I changed the date data type after unpivoting the columns, it gives me wrong dates ( all the dates year were 2024) , this affect the time intelligence function hence there is no year but the year 2024... how I can fix that….. please advise
How to change date target and actual on google sheet source data? I try to change date to another date, that shoe error "The column "01/09/2024" the table wasn't found" Thaks for help
< Actual Column 'Sales Person' in Table 'Actual' contains a duplicate value 'Andria Kimpton' and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table. Targets Load was cancelled by an error in loading a previous table. > i got this error after data cleaning . what should i do?
Hi @Chandoo Sir, I'm a Power Bi developer with 4+ yrs exp My Skills SQL, Power BI & Knowledge on Tableau Please suggest me additional course which will enhance my career Growth. Currently I'm in middle of learning Power of APPS & Automate, Shall I learn this ADF & Python Stuff or Power Platform?
Question- Why the dashboard showing wrong while filtering individual team like Tempo team showing 4 months out of 14 months however if see count the green variance column that only 3 on top of it.
@@chandoo_ Thank you for replying, no I'm taking about in your dashboard please count the column which is labels as green percentage% on top like team Temp I can see there only 3 column which mentioned green percentage for variance surpass vs target sales, also I know their in-card visuals 4 months showing which is fine, please suggest if understanding something incorrect.
Ya sure here is the time which is Team "Tempo" filter 17:48 see the top where header title is we met target 4 out of 14 however count the month column which lebels as green🟢 Dot % that is only 3 why that should be 4 because that's 🟢lebel showing we reached the target sales value
That is because of label density. Power BI automatically hides labels when they are too many of them. It just shows labels for important points. You can adjust the density to 100% (thus showing all labels all the time). By default it auto-hides labels for some points.
Hai chandoo Anna, when I have unpivoted other columns and shriked the remaining columns to date and sales and when I tried to load the data I am getting an error: "Column 'Sales Person' in Table 'Actual' contains a duplicate value 'Andria Kimpton' and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table." Please Help
The tables Actual and Targets have no direct relationship. The relationships are between Actual - calendar Actual - sales person Target - Calendar Target - sales person
Hmm.. nothing unusual there. When you select a salesperson (in the table), all visuals are showing the values for that salesperson. Are you seeing any wrong values?
@@chandoo_ somebody else (Rashid-7z..) has also commented regarding the same issue. Column chart title is not getting updated dynamically, columns are looking weird and the little chart below all the KPI cards is also not showing the correct values when you select a single salesperson from the table. I replaced both of these charts as Line charts, and they are now showing the correct values for a salesperson. I am unable to figure out the reason behind discrepancies in column charts.
@@chandoo_ When we filter the dashboard by selecting a single salesperson from the table, the little chart below the KPI cards is showing some really weird bars, also the column chart gets distorted completely. The chart heading does not get dynamically updated as well. I replaced all the column charts with line charts and then everything is working as expected. I am unable to figure out the reason behind this. There is another comment by @Rashid-qz7pt highlighting the same issue. You can also check your video from 20:36 mins. I can see the same issue.
I think this is a highlighting "bug" in Power BI when CF rules are also used. That is why our tiny win/loss chart is showing weird colors (the columns are right) when clicking on a person. Reg. chart title not chaging, that is expected. As we have the interaction set to "highlight" rather than "filter", the title won't change. When you use a line chart, it always "filters" so, the title changes. Everything else is as per normal behavior, but might seem strange if you are not used to seeing such interactions.
I'm having problem with my output for YTD Sales Actual, YTD Sales Target, YTD Variance, YTD Variance % showing - - YTD Sales Actual = CALCULATE([Total Sales Actual],DATESYTD('Calendar'[Date]))
If I don't use Var and write directly this formula COUNTROWS(FILTER(all('Calendar'),[Variance]>0)), It is still working. Why Var is required in this case
hey chandoo in the video the actual has only three columns but in reality there are 14 columns how am i supposed to make relationships same as that on the video?? please help u skipped that part
Hi could anyone help me, after adding YTD Sales Actual data into Reference label Series for all the 5 labels I'm getting same value as YTD Sales Actual $2M
Assuming you have already calculated YTD Actuals and YTD Targets, YTD Variance = [YTD Targets] - [YTD Actuals] To calculate YTD Actuals, use this logic: =CALCULATE([Total Actuals], DATESYTD(Calendar[date])) Same pattern for the YTD Targets too.
Come on mate. You can't expect a beginner to straight away make a dashboard. Take baby steps with other videos. I have plenty that go slow and explain all the basics. If in every video, I open by saying now start your computer and download Power BI then no one would watch.
1) When I connected my Calendar to Actual, it did not automatically connected it to Target one like yours did. Why? 2) Unable to make further YTD measures for references or of possible results are different. Have tried multiple times in new measure Hence left the video in the midst because of (2). No point of moving forward when not getting it
🏆Participate in my Dashboard Competition 👉 bit.ly/3xgC1WB
if you are don't make right video.. that you don't upload wrong video.
Congrats for being mentioned in the top Excel youtubers list in the world
Someone suggested me this channel and I cant thank him enough for this recommendation. words fall short.
In all my time of learning on RUclips, i have never got so much in 20 minutes its crazy 😅 Like. Thank you!
Hello chandu , I am really excited to take excel course but due to price 247$ is very much high , can reduce for price for university students , hoping you could reply on these , and thanks for giving datasets for SQL sessions ,
Hi bro if you're interested I can provide videos only for 1k all power bi+ssas+azure
I am very impressed, outstanding job on tis dashboard. Thank you for being you, and for your creative and intuitive insight in to telling stories with data!
Wow, thank you!
I definitely felt in love with the report despite not meeting the targets. Please show us how you made it look more beautiful at the end
You make dashboards like a walk in the park.
Sir Namaste
Your All videos very knowledgeable.
Hi Chandoo.
All your Trainings are Very interesting. You make a lot of effort to prepare them; which gives videos with good quality . You are using a very good and simple teaching. Thank you.
Incredible!! Thanks lot for this video Sir!
Hi Chandoo , i feel variance should be Calculated as Total_Target - Total_Actual
because target is what needs to be acheived and actual is what has been achived.
In that case, you will get a positive variance when we do not meet the target. As positive numbers indicate good outcomes, the logic needs to be actual-target.
can we shrink the size of last visual which has months showing if target met or not having red and green colors...the column visual that you have put out there. if i shrink the width of it, few months are being hidden. any way dear Chandoo to still keep them showing...
Hi Chandoo, when am creating the visual for measure YTD actual, am getting card visual as " Blank ". Could you please help me with this? Hope the measure is right! : YTD sales actual = CALCULATE([Total sales actual], DATESYTD('Calendar'[Date]))
me too!
Me too!
me too! can anyone help me to resolve??
This youtuber cut a lot of important moments. If you get stuck for this, in "Actual", change the data type of the "Date" column from Text to Date.
@@na-zw8ju Thank a lots. can resolve it now
Excellent.... thanks for sharing 👍
Why I am getting difference in some values from what you got and what I got using the same method?
Hi Chandoo! When you choose an individual sales person at 20:40 you get Month Target Reached = 7, however the little chart below clearly shows smth different, besides above it says 'we met targets 2 out of 14 month. How could we fix that?
Hi, you can fix this issue by changing the bar/column charts to line charts. Line charts are perfectly filtering out data for individual salesperson. I am yet to figure out the reason.
This was great, thanks Chandoo!
I love how this video is challenging a beginner like me to figure out nuances instead of spoon feeding every step. I managed to solve most of my problems, but somehow months target reached is still 0 and my column chart for target vs actual sales shows no data for any of the in between months. Why?
Ok, got a part of the answer - it is treating the dates as in mm/dd/yyyy format!
Beautiful despite missing targets So fun. So clean. So clear
simply fantastic anna
Happy Ugadi anna
This is just awesome. Thank you Sir.
This is so good
Amazing dashboard
Wonderful video but i have a question on i am unable to get the ytd sales actual, ytd variance, ytd variance % , ytd sales target. Please answer my question i am unable to proceed forward.
Why are you unable to get them? The clues and example is already shown in the video.
ytd sales target formula, ytd variance , ytd variance % is missing in the vvideo
@@chandoo_help
You are very good. Thank you for so many information in a very short time.
That's what set him apart from other youtubers!
HI chandoo, in minute 8, YTD Sales Actual = CALCULATE([Total Sales Actual], DATESYTD('Calender'[Date]), this formula didnt work in my case? 'Total Sales Actual' didnt read by CALCULATE function. however it was working fine in previous formulas. Please help me with this. Thank you.
Yes, I am also facing same issue
@@Hercules90015 same
@@Hercules90015 were you guys able to solve it? this formula is not working for YTD target, variance, and %variance.
@@ambernaz6793 same here
Hi Chandoo, thanks for the video, certain steps of the video have been removed, would have been better if those also were included. Anyways thanks for the video
Hi Chandooo Anna,
I have reached till dax function - target for the month, but I am not getting any expected value, it results this _ _ and there are no errors in the formula. Can you please help me rectify this?
Hi Chandoo, I was your channel following for months now and your videos are very useful. How can we use measures in a new measure as in the above dashboard i can't add Variance when creating Months target reached measure. If you can reply it would be very helpful. Thanks.
You make it easy and cool.
Nice smile congratulations. You looks fantastic.
Excellent dashboard sir!!
You are the best. Thanks
Good one!
Nice one Chandoo
Hello Chandoo Bruh , I have a query regrading Months Target Reached Formula , Variance didnt comes in option .will i create a Dax Calculation . Kindly Sort Out this
thank you so much for the content you have been posting on RUclips Channel. May I suggest/ask something? Can you please teach us how to create a multilanguage Dashboard in Power BI?
I have been looking for something on Google, and RUclips and so far I couldn't find anything. Please, can you help me with this?
Hello, Chandoo Brother, you skip two formulas 1. YTD Variance 2. YTD Variance % during editing the video so I Can't understand it. Please tell me how can I calculate these formulas? Because I am beginner.
I'm very impressed ❤❤
What is the DAx to be used to get previous month
Hi Sir,
I it’s helpful I learned lot from your video I would like to request your all data shows only about sales data if you can do some dashboard with supply chain and inventory management data it will be helpful for other professionals.
It’s just request.
Thank you 🙏🏻
Noted
Chandoo ji your competition requires in depth knowledge.
Thanks bro for making this video
Hi chandoo
if I am calculate -- Variance = [Total Actual Sales] - Targets[Total Sales Target] how to get variance in Positive value that is Impossible because your Actual sales = $1,89,49,239 and Target is $1,93,16,100 and your variance % is also wrong.. Can you proved that
Hi Chandoo, YTD Sales Actual = CALCULATE([Total Sales Actual], DATESYTD('Calendar'[Date]), this formula didn't work in my case. 'Total Sales Actual' didn't read by CALCULATE function. however, it was working fine in previous formulas. Please help me with this.
YTD Variance % is also showing -100%.
Thank you.
i have also same probelm
It is working now YTD Sales Actual = CALCULATE([Total Actual Sales], DATESYTD('Calendar'[Date]))
Hello, I hope you are well. I am a student. I need help with the decision support system. I am looking for training in this subject. Is it a requirement to understand the ssis ssas ssrs program or Power Bi just to implement my graduation project?
Excellent!
Chandoo i had a doubt in the 'Month Target Reached' though i used the correct dax measure like you ,it results 14 but it's actually 2, please solve my issue anyone!
The number you see depends on the filter / evaluation context. Make sure you are not filtering something out and have used the dax as demoed in the video.
@@chandoo_ what a dumb excuse. Say it Chandoo, you yourself don't know.
Helpful thanks so much
can you please make a video to explain time intelligence functions in details
Chando Bhai, can you please do a time series analysis in Power BI it seems quite complicated
I'm not able to find the link for data set. Can anybody help me ?
Happy Ugadi
Hii sir if the data is load it's showing error in actual sales andria. Kimpton and this not allowed for columns on the one side of a many to one relationship or for columns that are used as the primary key of a table. Ani vasthundhi sir em cheyyali ippudu
Please create advanced level power bi financial dashboard for financial planning and analysis domain covering income tax statement, cash flow, variance and ratio analysis OR some banking detail dashboard covering total disbursement count, value and sanction count and value, total aum(asset under management), gross income, ltv%, bounce rate,ROI%
when I changed the date data type after unpivoting the columns, it gives me wrong dates ( all the dates year were 2024) , this affect the time intelligence function hence there is no year but the year 2024... how I can fix that….. please advise
Hi Chandoo, Im not getting Total sales actual= Sum(actual [sales]) it is not showing sales
How to change date target and actual on google sheet source data?
I try to change date to another date, that shoe error "The column "01/09/2024" the table wasn't found"
Thaks for help
< Actual
Column 'Sales Person' in Table 'Actual' contains a duplicate value 'Andria Kimpton' and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table.
Targets
Load was cancelled by an error in loading a previous table. > i got this error after data cleaning . what should i do?
Hi @Chandoo Sir,
I'm a Power Bi developer with 4+ yrs exp
My Skills
SQL, Power BI & Knowledge on Tableau
Please suggest me additional course which will enhance my career Growth.
Currently I'm in middle of learning Power of APPS & Automate, Shall I learn this ADF & Python Stuff or Power Platform?
Question- Why the dashboard showing wrong while filtering individual team like Tempo team showing 4 months out of 14 months however if see count the green variance column that only 3 on top of it.
In my case, it shows 4 green bars and says 4 out of 14 months. So may be you have a horizontal scrollbar on the graph?
@@chandoo_ Thank you for replying, no I'm taking about in your dashboard please count the column which is labels as green percentage% on top like team Temp I can see there only 3 column which mentioned green percentage for variance surpass vs
target sales, also I know their in-card visuals 4 months showing which is fine, please suggest if understanding something incorrect.
Not sure what you mean. If it is shown in the video, can you share the timestamp so I can examine further.
Ya sure here is the time which is Team "Tempo" filter 17:48 see the top where header title is we met target 4 out of 14 however count the month column which lebels as green🟢 Dot % that is only 3 why that should be 4 because that's 🟢lebel showing we reached the target sales value
That is because of label density. Power BI automatically hides labels when they are too many of them. It just shows labels for important points. You can adjust the density to 100% (thus showing all labels all the time). By default it auto-hides labels for some points.
hey man , can you give formula for YTD VARIANCE, YTD VARIANCE %, AND YTD SALES TARGET
Great. Thnks a lot sir
Hai chandoo Anna, when I have unpivoted other columns and shriked the remaining columns to date and sales and when I tried to load the data I am getting an error: "Column 'Sales Person' in Table 'Actual' contains a duplicate value 'Andria Kimpton' and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table."
Please Help
The tables Actual and Targets have no direct relationship. The relationships are between
Actual - calendar
Actual - sales person
Target - Calendar
Target - sales person
How did you got M in the sales data, mine is just showing number
Power BI automatically shows it.
why in my hand YTD returns blank
Do you have a beginner video on Power BI and DAX formula?
I do. Check this - ruclips.net/video/PQ5lALdFHCU/видео.html
Hi Chandoo, please do reply to my query. Why is the whole dashboard behaving weirdly when filtered with salesperson name?
Hmm.. nothing unusual there. When you select a salesperson (in the table), all visuals are showing the values for that salesperson. Are you seeing any wrong values?
@@chandoo_ somebody else (Rashid-7z..) has also commented regarding the same issue. Column chart title is not getting updated dynamically, columns are looking weird and the little chart below all the KPI cards is also not showing the correct values when you select a single salesperson from the table. I replaced both of these charts as Line charts, and they are now showing the correct values for a salesperson. I am unable to figure out the reason behind discrepancies in column charts.
@@chandoo_ When we filter the dashboard by selecting a single salesperson from the table, the little chart below the KPI cards is showing some really weird bars, also the column chart gets distorted completely. The chart heading does not get dynamically updated as well. I replaced all the column charts with line charts and then everything is working as expected. I am unable to figure out the reason behind this. There is another comment by
@Rashid-qz7pt highlighting the same issue.
You can also check your video from 20:36 mins. I can see the same issue.
I think this is a highlighting "bug" in Power BI when CF rules are also used. That is why our tiny win/loss chart is showing weird colors (the columns are right) when clicking on a person.
Reg. chart title not chaging, that is expected. As we have the interaction set to "highlight" rather than "filter", the title won't change. When you use a line chart, it always "filters" so, the title changes. Everything else is as per normal behavior, but might seem strange if you are not used to seeing such interactions.
I'm having problem with my output for
YTD Sales Actual, YTD Sales Target, YTD Variance, YTD Variance % showing - -
YTD Sales Actual = CALCULATE([Total Sales Actual],DATESYTD('Calendar'[Date]))
Hello Nick, please use the following
YTD Sales Actual = CALCULATE([Total Sales Actual], DATESYTD(Actual[Month]))
YTD Sales Target = CALCULATE([Total Sales Target],DATESYTD(Targets[Month]))
YTD Variance = [YTD Sales Actual]-[YTD Sales Target]
YTD Variance % = DIVIDE([YTD Variance],[YTD Sales Target])
@@tjoelgeorge tnx
@@tjoelgeorge When I do this, I get an error message.
Any ideas why?
i did the same and was prompted to format the the date tables to date type. Then youll get the right answer.@@michelcockerham2109
If I don't use Var and write directly this formula COUNTROWS(FILTER(all('Calendar'),[Variance]>0)), It is still working. Why Var is required in this case
You can do that too. I like using variables so that my DAX looks better and lets me add conditions easily later.
@@chandoo_ thanks for your reply
Fantastic video chandoo❤🎉
Thanks 🤗
Hi chandoo, Can I have this data set pls.
Do you make custom dashboards? I want one for my business!
I know someone who makes custom Power BI Dashboards for businesses. He has helped businesses 2x their revenue! Let me know if you'd be interested.
my win loss chart is all showing 1 and all in green.. what could be the reason
tables are not connecting
hey chandoo in the video the actual has only three columns but in reality there are 14 columns
how am i supposed to make relationships same as that on the video?? please help u skipped that part
Hmm.. I explain that step in the data prep part. You need to unpivot both actual and target tables.
Got it thanks man loved the tutorial
Sir please do a videos kn informatica
make vdo including copilot in BI
Hi could anyone help me, after adding YTD Sales Actual data into Reference label Series for all the 5 labels I'm getting same value as YTD Sales Actual $2M
You need to set the label individually to each item.
@@chandoo_ Hi, Chandoo. Yes, I have done that. In all five categories, I'm getting the same figure as YTD Sales Actual $2M.
Check the measure logic. Test by first making a card with all 5 values.
Hi sir, how to create YTD variance. Can u plz explain
Assuming you have already calculated YTD Actuals and YTD Targets,
YTD Variance = [YTD Targets] - [YTD Actuals]
To calculate YTD Actuals, use this logic:
=CALCULATE([Total Actuals], DATESYTD(Calendar[date]))
Same pattern for the YTD Targets too.
@@chandoo_The video should be in a simple form so that beginners can learn from it as well
Come on mate. You can't expect a beginner to straight away make a dashboard. Take baby steps with other videos. I have plenty that go slow and explain all the basics. If in every video, I open by saying now start your computer and download Power BI then no one would watch.
Sir Can you Make market stock portfolio report in Excel by Google finance.
Hi Chandoo. how are you? are you available now?
can you share this dashboard
nice tshirt
Hello chandu
Naaku power bi full course kavali Ela please response
Please visit chandoo.org/wp/power-bi-course and sign up
@@chandoo_ replying chesinanduku chala thanks Anna garu I am from Telangana
sir images not work 😢
How is your variance $367k when both actual and target sales is $19m 😳
why my month TARGET REACH IS 14😐
Chandoo! Are you here?
Yes... how can I help?
too fast ... Dax fn are not explained
1) When I connected my Calendar to Actual, it did not automatically connected it to Target one like yours did. Why?
2) Unable to make further YTD measures for references or of possible results are different. Have tried multiple times in new measure
Hence left the video in the midst because of (2). No point of moving forward when not getting it