@@AnthonySmoak Will you also make the part 2 of this video? I am struggling to make that ""Revenue difference by customer chart" I have just started learning DAX :-(
How would I add Fiscal Year Dates to the calendar? We have an odd Fiscal Year and I need to be able to sort and filter in that manner. I would need FY by date, month and Year.
Thank you for the video sir...can you please explain dashboard in detail ? how you created one chart for positive YOY Revenue difference by Customer and Negative YOY Revenue difference by Customer
Thank you sir for your amazing videos, I am sorry this comment is coming a year late. Please sir, I noticed that in the power BI, if we want to calculate the YOY or other time series data, we have to have a custom date table or field, is it the same with the Tableau? Do we have to have a custom date table or field to calculate a time series data? Thank you sir
Very nice video .....................thanks to sharing this video with us can you please share with me this excel file data which you used for this power BI if possible
Great tutorial. I'm getting hung up in Key Measures. I"m getting too many aruguments with: Revenue LY = CALCULATE(SUM(Sheet1[Trans Amount],SAMEPERIODLASTYEAR('Calendar Table'[Date]))
Thanks, but I can't get the formula right. see below Calendar Table = VAR BaseCalendar= CALENDAR(DATE(2009,1,1),DATE(2020,12,31)) RETURN GENERATE( BaseCalendar, VAR BaseDate =[Date] VAR YearDate = YEAR(BaseDate) VAR MonthNumber = MONTH(BaseDate) VAR YearMonthNumber=YearDate*12+MonthNumber-1 VAR QTR = CONCATENATE ("Q",ROUNDUP(MONTH([Date])/3,0) RETURN ROW( "Year",YearDate, "Month Number",MonthNumber, "Month",FORMAT (BaseDate,"mmmm"), "Year Month Number",YearMonthNumber, "Year Month",FORMAT (BaseDate,"mmm yy"), "QTR",QTR))
This is art. Getting a little crazy over differences between power bi version haha
You're too kind!
This is so incredibly helpful! You seriously cleared up so many questions I've had in 13 min.
Glad the video worked for you!
Thank you very much! This was very helpful.
You're very welcome. I appreciate the comment!
Thank you for sharing 🙏
Thanks for taking the time to leave a comment!
You are the best. Best wishes from Germany.
You're too kind! Great that you're watching from Germany!
@@AnthonySmoak Will you also make the part 2 of this video? I am struggling to make that ""Revenue difference by customer chart" I have just started learning DAX :-(
Thank You very much. Could you please share the link for data source
How would I add Fiscal Year Dates to the calendar? We have an odd Fiscal Year and I need to be able to sort and filter in that manner. I would need FY by date, month and Year.
Brilliant!
THank you SO MUCH. It's very helpful!!
Thank you!
Thank you for the video sir...can you please explain dashboard in detail ? how you created one chart for positive YOY Revenue difference by Customer and Negative YOY Revenue difference by Customer
Thanks for watching. One day I may offer that video as part of a paid training course.
Thank you sir for your amazing videos, I am sorry this comment is coming a year late.
Please sir, I noticed that in the power BI, if we want to calculate the YOY or other time series data, we have to have a custom date table or field, is it the same with the Tableau? Do we have to have a custom date table or field to calculate a time series data?
Thank you sir
Very nice video .....................thanks to sharing this video with us can you please share with me this excel file data which you used for this power BI
if possible
Great tutorial. I'm getting hung up in Key Measures. I"m getting too many aruguments with:
Revenue LY = CALCULATE(SUM(Sheet1[Trans Amount],SAMEPERIODLASTYEAR('Calendar Table'[Date]))
This is great - Can you please share the dashboard template?
Very Nice!!! Could you please share the data set? Tks
How can you do the same but choose what two years compare?
Can you please share the dashboard template
sir can you share data set for practicing...
this is a good tutorial - just need to fix the microphone. It's buzzing
Sr. Could you share the dataset please?
can you please share the data sheet
Can you share pbix, please ?
why have you not provided the data link?
I didn't know I was obligated to do so!
@@AnthonySmoak if you can provide data set we can practice along with your video!!
Download link?
Thanks, but I can't get the formula right. see below
Calendar Table =
VAR BaseCalendar=
CALENDAR(DATE(2009,1,1),DATE(2020,12,31))
RETURN
GENERATE(
BaseCalendar,
VAR BaseDate =[Date]
VAR YearDate = YEAR(BaseDate)
VAR MonthNumber = MONTH(BaseDate)
VAR YearMonthNumber=YearDate*12+MonthNumber-1
VAR QTR = CONCATENATE ("Q",ROUNDUP(MONTH([Date])/3,0)
RETURN ROW(
"Year",YearDate,
"Month Number",MonthNumber,
"Month",FORMAT (BaseDate,"mmmm"),
"Year Month Number",YearMonthNumber,
"Year Month",FORMAT (BaseDate,"mmm yy"),
"QTR",QTR))
You are missing end bracket at line 11
Can I have the dataset
No template & data set...no subscribe or like.😬 Quid-pro-quo.