High.
So let's get started in this video.
We will be learning about time intelligence functions and some of the most important time intelligence
functions like total YTD duty and total MTD.
So first of all what really time intelligence is so in these matters of your article as you can see
time intelligence functions supports the need of business intelligence analysis and enables us to manipulate
data using time periods days months quarters etc..
So it helps us in in analyzing our data it with any historical data like last year or two years they
are two years back of data so that we can analyze our current data with the historic when they make
the decisions based on those.
So time and diligence functions are really very very helpful when it comes to the need of our business.
So let's just learn what really is this time that it has functions.
So today we'll be first learning about total YTD.
So these are the functions to do.
Why did the dirty deed into MTD are almost the same.
Let's look at them one by one.
So in my table I will take the order date and my seeds.
So I have the sales data consisting of the FROM year 2010 to 2017.
So I have this says.
So now for us we can do total right duty.
What it does is it evaluates Yertle that expression as part our contacts.
So first of all we need to clear the measure.
So we will right click on our table and click on new measure.
Now I will name it like total YTD and this is how I would go.
All you have to type is total and you can see these three functions.
The total MDD to do the invited me I will take first total YTD.
Now when you click and you can see it's in the pool of what we have to write for.
So first we need to add the expression to an expression it will.
We want to write ours.
We want to dig ourselves into to we take the sum of all the done.
So I will type some.
And then I will take my sister to Skolem.
So I source for that.
And here it is now after expression I need to put the data here.
So here is my order.
And I will close the bracket and this is all I want to tell YTB.
So first of all quickly I will be creating these three major and then I will be explaining them one
by one.
That would be pretty easy for you.
So now I've got a total of I do the same thing goes with creating total Kupelian total MTD as well.
So I will just go with this and then click on it and click on you measure second measure will total
to the everything will be same except all I have to do is type the order to do the function and the
rest will be the same.
There you go.
Just one more major
and this will be named this Bortle M B.
B.
There you go.
I.
So now I've created all these three major.
I would simply add them in my table YTD QED and MDD.
So let's see how they really work.
Too as you can see this is that ordnances there to in 2010 January I have 24000 772 dollars of sales
then in fab than March.
So now first take a look at total YTD total but divided evenly.
Give us to eat or duded value so in January I have been to 4000 772 in February it will be giving us
1 0 8 2 3 5.
So what it really does is it will add January past February and it will give either to the date of total
sales.
So it will add Baudot months of sales and give us the total.
Then in March it will add this total along with the march and give us the total ear to bid up to March.
So that will give us total up to the date of values.
This will go on for a year as soon as the new year comes like January 2011 it will again start from
the very beginning.
So in January they were tied with thousands of sales in February there were 58000 which will which is
which is because it will add 22000 February of February and today after the end of January and it will
give us total ear to be values.
This is our total ear to be at work.
So if now we understood the concept of total YTD it would be easy for you to listen to the quarter to
this was for either.
Now this will be for the third quarter due to the quarter will consist of 24 than 1 0 and 6:59 So this
is total one quarter for the next quarter it will again reset and from Apple it will show the value
of 41000 of Apple.
Then it will show the combined value of every lead in me.
And then in doing it with a combined value of April May and June to date is October 2 to debug.
And the last remaining is total MDD.
So it was it was it is issuing total month to do the trade values as you can see here each and every
month.
Well you so these are some of the most commonly used and really important time intelligence function
we will take a look at one of those very interesting time diligence funds function in our next video.
But before moving ahead for the next we do I just want to show something.
Pardon.
Supposing your data you have to do a lot of calculations by creating calculated measures so of one of
the best practice here is just to not mess with your data updating the table.
It is good to create a new table with just consists of measures.
So what I do is I will create a new table here.
And let's say I left to just enter the door.
I'll create a new table here.
I will name it.
Let's image this.
All right.
There you go.
Now what I will do here is all that three majors would have just not created.
I will move them to Dharmesh or stable.
So are to do that all you have to do is here in the MDD.
These are the three majors you can see other top Benelli or home view modeling.
You'll have to go to the modeling pan and here you can see it is asking us the home table.
So right now the home table of our two MDD is this data which is our stable.
What we want is we just want to move it to the Majors table.
So I will put it in the measures table.
Now here is this particular column is in the Majors table.
One of the good things about the merger is we can move them from any one people to another table and
they can they will still work the very same if if they are in if they are related.
So I will just simply move them to our newly created table and delete this blank column 1.
There you go.
So I have created to do the same.
I will also move to UDD and total YTD.
This is one of the good practices which you must follow when you are really having lots and lots of
calculated majors there.
So it's pretty easy to maintain all of your majors so that you can use them any time.
So now we have this one particular table on lever measures in the coming with us whatever measures which
we will be creating We will be adding them in this major stable only that will be easy for us to keep
a record of it.
So that's it for now.
We will continue in the next lecture.
Thank you.