How to calculate MTD QTD YTD in Power BI DAX Tutorial (6/50)

[@mangkhongsai9029]

I have been struggling for a month and this video has help me understand in a rather different way. Thank you and may your videos excel each time.

[@AnalyticswithNags]

Thanks keep learning. Share this channel with friends and colleagues

[@siddheshdandagavhal9804]

1) MTD: TotalMTD(SUM(Sales[Quantity]), DimDate[Date].[Date]) #You can also use quick measure for this 2) YTD: TotalY TD(SUM(Sales[Quantity]), DimDate[Date].[Date]) 3) QTD: TotalQTD(SUM(Sales[Quantity]), DimDate[Date].[Date]) 4) YTD by financial year: YTD: TotalY TD(SUM(Sales[Quantity]), DimDate[Date].[Date], "3/31")

[@kirant96]

Have been reading book written by MS guy for DAX. But IMO this is the best dax content i have seeen so far.

[@AnalyticswithNags]

Please share this content with your friends and colleagues

[@newlifefoundation3917]

most underrated channel on youtube interms of power bi learning sir you are great nobody is giving the live project keep it up a lot of love -priya

[@AnalyticswithNags]

Thanks for your concern. Hope this channel is visible to all data analytics learners soon Share this Channel with your friends and colleagues. Thanks once again

[@parthibangopi8393]

Simple snd clean explanation. I started learning DAX. Thank you

[@irfandaud7380]

Thank You . Excellent Video ... + Financial Year explanation also make this lesson interesting further... Thank You

[@AnalyticswithNags]

Thanks

[@divyagand2580]

simple but powerful tips. fiscal year tip was bonus.

[@AnalyticswithNags]

Thanks keep learning share this channel with friends and colleagues

[@mannyvillanueva2354]

Where do I find your video on creating date tables?

[@manoharkulat]

Thank you for the clear explanation, keep going. You are doing great work.👍

[@AnalyticswithNags]

Thank you, I will

[@rajs1697]

Thank you for the detailed explanation on the concept. I am new to PowerBI and I do have one question on this video. On the table the totals for MTD, QTD and YTD are not appearing on your chart. I followed the steps as explained but the totals are appearing, tried formatting through visuals but does not work. Could you please let me know if I have done something wrong?

[@AnalyticswithNags]

That’s ok. Until your MTD calculation works fine. Surely it is some format option even I don’t remember

[@AArora81]

Easy to understand and good simple content. Thanks for sharing knowledge.

[@AnalyticswithNags]

Glad it was helpful! Keep learning and Sharing.

[@mikeycbd]

Thank you, already subscribed to your channel. First time using MTD. Will try YTD as well. Mike - Melbourne Au.

[@AnalyticswithNags]

Awesome, thank you!

[@manishlalsah8075]

Thankyou sir, All doubts are cleared.

[@AnalyticswithNags]

Always welcome

[@atifsaeed4980]

Dear Naga, Is there any video where you have shown how to add a calendar on the dashboard which can be used to filter different options.

[@AnalyticswithNags]

Check video on DimDate creation

[@jeepsiejohnsonmarinas9533]

Thanks for the video. But can you compute the quantity sold by MTD or YTD by Product Name or Product Category. Thank you hoping for feedback.

[@AnalyticswithNags]

Yes. Ensure you filter any year/month combination

[@gaddesiva1549]

Separate Date table is mandatory to calculate MTD,YTD,QTD? by using fact table sales date we can cal MTD,YTD,QTD?

[@AnalyticswithNags]

Yes. It is good practise to use dedicated date dimension. Not only for calculations, if you have multiple facts having common date dimension between fact is a mandatory Design principle kzbin.info/www/bejne/eJ_UpXWufMeiZq8

[@Vaibhavsemwal-k2g]

Really appreciate your efforts for the level of content for the power bi aspirants. Just a question how do you create dim date component ?.Could not find in the video.

[@AnalyticswithNags]

Check playlists of this channel and explore topics on the similar line requested by you.

[@Ssinger123]

U have explained everything... Can u say how to calculate WTD and previous WTD i m struggling with it.. Thanks in advance.

[@AnalyticswithNags]

Soon will make video on this

[@Ssinger123]

@@AnalyticswithNags tqsm

[@adventuresofvyomandkeshav3036]

thanku sir.very helpful

[@AnalyticswithNags]

Thanks keep learning share this channel with friends and colleagues

[@patlollaakhila397]

Really i didn't understood this topic in past but now i got clear idea on it really thank you sir ,iam clear now😊

[@AnalyticswithNags]

thank you , keep learning

[@sreekanth8395]

THANKS NAG

[@AnalyticswithNags]

Thanks keep learning share this channel with friends and colleagues

[@shrutisharma1434]

It was really a well explained video thank you so much .

[@AnalyticswithNags]

Thanks keep learning and share this channel with friends and colleagues

[@shrutisharma1434]

@@AnalyticswithNags sure 🙂

[@EvaDarknes]

>Hello Naga, thank you for sharing your knowledge my friend.. wondering if you can help me with an attrition measure. I'm calculating a YTD Attrition and for that I need the total drop offs per year (I already have it using the YTD quick measure and your explanation), however I also need the average active HC, kinnda like a YTD average or some sorta, but I´m not able to find it and the "avg option" is not available under the quick measure label. Thank you again bro. kuddos from Colombia

[@AnalyticswithNags]

Sorry don’t have time to reply comments and provide solutions. keep learning share this channel with friends and colleagues

[@YassirMirghani]

Great. Thank you

[@shubhamyadav-ig8bi]

do we have to use a new data file for this video or else the file that we downloaded in the first video ????????

[@AnalyticswithNags]

you can download online, database/powerbi/ssis/ssas/scripts/azure/app everything under here - - > github.com/microsoft/sql-server-samples/tree/master/samples/databases/wide-world-importers

[@shivammishra-mk9jp]

Please make a video with end to end project intermediate to high level also please try to provide data set that you use while making video.

[@AnalyticswithNags]

Watch end to end playlist

[@poojapohani4536]

Hello sir. I am following along your dax tutorial playlist. In this video, I am stuck, I watched your date dimension video and created the date table for this dataset and created table visualization, I selected the year, month name and day columns from my date dim table, but the moment I select quantity column from data table, it shows 6555 (sum of quantity) and nothing in year, month name and day column in the table visualization. How do I get it to show quantity for individual rows instead of summarizing it. When I click on don't summarize option for quantity, it gives error in visualization. What to do? Please help, your content and teaching methodology is great and I want to finish this dax playlist.

[@AnalyticswithNags]

Watch what is .date in date table / dimension video. That may help. When you stuck, no need to stop here continue with other videos. Just understand the concepts

[@sidindian1982]

Ma'am even i have same problem , i have mailed to the admin of this vedio , still no response .. I have created Date.Dim in_query code from google , when i started to import Quantity from the sales(dataset) .. its showing 6555 iterative problem .. Now how to fix ?? big problem

[@salidandigopi4358]

Could you pls explain about why u took , Dim date(date).(date)..,please explain clearly , I did not understand

[@AnalyticswithNags]

Watch this video kzbin.info/www/bejne/hoGVZKqpba1jjqc

[@salidandigopi4358]

Now I cleared , Thnak you so much

[@rajunalgunta6106]

If we are having MTD till today ie. 12th Dec 2020 and we have to compare MTD with same no. Of days with previous year 12 Dec 2019.... How can I do that??

[@AnalyticswithNags]

Use calculate ( total YTD , date add) this should work

[@williamarthur4801]

What is the name of the video which explains why DimDate[date].[date] syntax?

[@AnalyticswithNags]

Check this out. What is .Date of Date Column in DAX Calculation | Power BI Tutorial (50/50) kzbin.info/www/bejne/hoGVZKqpba1jjqc

[@mahendharyadav2657]

Here while calculating ytd quater wise,the month should start from april but it is starting from jan

[@AnalyticswithNags]

Filter the fiscal year

[@rammohanreddy9014]

Hi nagendira, as you have shown FYQTD it cumulated from April but visual is showing from January can you tell me how to start it from April (or whatever financial month starting)

[@nagendrakg5062]

For QTD there is no financial year. I hope you are asking about FY YTD . FY 2017 is from Apr 2016 till Mar 2017. The data I have starting from Jan 2017. So for FY 2017 the YTD started from Jan2017 and ends at mar 2017. Again the YTD starts from Apr 2017 ...Watch second chart at the bottom ...after 14.30 secs

[@rammohanreddy9014]

@@nagendrakg5062 ok thank you

[@AnalyticswithNags]

Thank you

[@krishnaskills7459]

Hi sir ur explanation is very nice plz provide dim date table for practise purpose

[@AnalyticswithNags]

sure

[@GauravMishra-uo2fq]

Hi, I just want to know how did you get the DimDate table since in the dataset provided in the description box doesn't have it

[@AnalyticswithNags]

kzbin.info/www/bejne/eJ_UpXWufMeiZq8

[@gaddesiva1549]

by using seperate calander table i'm trying to cal MTD, i don't have any data from jan 1-jan 6 and jan 10-jan 15 remaining days i have data.in table visualisation Quantiy column those dates are showing null and in MTD column data repeated in those nulls data row so i don't want show nulls data and i want only whatever dates data i have and shows those dates data quanty without showing Nulls and those dates data MTD without repeated data .i hope you understand my question? please clarify my doubt.

[@AnalyticswithNags]

Use If condition before measure

[@mohshalsh5965]

How could i generate a dynamic table of Current/YTD/MAT with multiple selections of year month slicer?

[@AnalyticswithNags]

Soon will create video on this topic

[@Infa.Only.-bm8id]

Hello nags, could you please tell me regarding the formula for dim date table or plse let me know for how many years you created the table dimdate ?? . egarly waiting for reply

[@AnalyticswithNags]

Check power bi Complete playlist

[@sd3117]

Hi sir, Thank you for such valuable content! I had a doubt, as for 2nd question of Financial year, we skipped 'Filter' part in TOTALYTD DAX, so isn't it necessary to add two commas before writing "3/31"?

[@AnalyticswithNags]

Yes

[@sidindian1982]

@@AnalyticswithNags Sir , sales & dimdate are missing in dataset

[@erudition4788]

Very nicely explained. You mentioned you will create a video which explains why dimdate date.date is selected. Please share link of that video. Thanks

[@AnalyticswithNags]

If we are not creating the date table and link it to fact and mark the date table as date..it will create individual date table in power bi....In this case you no need to use Sale.saledate.date instead use dimdate.date.

[@aiinabox1260]

good question, in fact, I too had the same doubt

[@aiinabox1260]

@@AnalyticswithNags super

[@abhishekawari919]

IN YTD, how we can filter the date till a specific range, can you please give some example ?

[@AnalyticswithNags]

Check the video show data till selected month

[@shrutisharma1434]

I want to to compare WTD growth to last week growth for same days.(Monday to Sunday) for ex if as if today on 5th may . week started from Monday i.e 2nd may so I want to compare 2 to 5th may (total 4 days) sales to 25th to 28th april (total 4 days). what should I do in this case and it should be dynamic .Thank you in advance :D

[@AnalyticswithNags]

Soon I will make a video on this

[@sunnybhushan5210]

How quantity is taken in table , in my case it is showing sum of quantities.

[@AnalyticswithNags]

Not sure about your question

[@kalyanisri758]

Hi can I ask one question without SQL can you learn power bi

[@AnalyticswithNags]

Yes. If you are business user then no need of sql. If you are looking for a job then you should learn SQL first or parallel while learning power bi

[@jyotidatta2126]

Can we use a measure as a parameter while creating another measure?

[@AnalyticswithNags]

Check the “what if analysis”video. Search in channel home page

[@akashhanchatet-2842]

Thank you sir 🙏🏻❤

[@AnalyticswithNags]

Most welcome

[@hindi-english1664]

what is the least difference between DATESMTD and TOTALMTD?

[@AnalyticswithNags]

Watch this video kzbin.info/www/bejne/d3fckoyOabKhrck

[@nageshreddy8062]

Hai I Am new to power bi can please tell me how to create date table based on source table

[@AnalyticswithNags]

Refer this. kzbin.info/www/bejne/eJ_UpXWufMeiZq8

[@westnewstrending-usukeu8338]

Love you sir ❤️🙏😊

[@bzflowerbee]

That is very easy to understand consider this is the calendar year first day starts on January 1st. But, our company fiscal year is 445 calendar, first day starts in December. So, I have to create a calendar table with start and end date. If I want to create MTD, QTD and YTD measure, would the concept still be the same? Thank you so much for sharing.

[@AnalyticswithNags]

YTD works when you have standard fiscal year of 365 days and it can start any month. i.e either April or July. In your case you have 445 days, for that you need to create a logic that contains the Fiscal year column in calendar Table then use this new column for your YTD calculations. For QTD / MTD I hope you don't find any issues your existing calculations works fine. Try yourself , i will soon make video on this.

[@bzflowerbee]

@@AnalyticswithNags Thank you for your comments. Yes, I have been trying this for months and searched everywhere including the Power Bi Community, but I just can't find one that I understand. I mean, I don't want to just copy and paste their code, I want to understand it. There is one KZbin I found that I have been watching for several times and I understand exactly what he did; however, I don't understand the parameter part. I followed his steps through but my years are different. Our fiscal 2021 started on December 20, 2020. Here is the KZbin in case you are interested. kzbin.info/www/bejne/h2jNdGSmetqfn9U I'm looking forward to your video on the 445 calendar. Thank you again!

[@unnatipandey2909]

In Data table DATE is in '01-january-2016' format and while creating DimDate table we are giving #date(2016,01,01). both the date fields are in Diff format values .can you explain it.

[@siribn2657]

I have tried MTD on Financial sample data. the table itself has a date column. So I didn't create a separate date table. but I am getting the same sales total number for each month. not getting cummulative totals. y is it so?

[@AnalyticswithNags]

Use .date Dimdate[date].date

[@vinodkumarhs4000]

How to calculate previous day dispatches?

[@AnalyticswithNags]

Use Dax dateadd function

[@vinodkumarhs4000]

@@AnalyticswithNags Sir it is showing error as Date add only works with contiguous date selections , I had used same period last year function for that also it is showing same error. Kindly help me to resolve this.

[@amritsinghania2722]

Sir why we use dimdate[date].[Date] I mean why we use date in last bracket

[@AnalyticswithNags]

Watch the .date video on channel playlist

[@swapnachilakam1684]

Dear Sir, Can you please share date dim table to do this exercise

[@jaibalayya8853]

very usefullllll

[@AnalyticswithNags]

Thanks. Keep learning. Share this channel with friends and colleagues

[@prajwalB-x1r]

your teachining great , can you provide datset link

[@AnalyticswithNags]

Thanks keep learning

[@sakibzamanmohammad8895]

Brother If Growth percentage is showing -100% for previous year with no data how do I show it as blank. For example year 2019 has no data and i want to see growth percentage of 2021 and 2020 till June 21.

[@AnalyticswithNags]

Check the respective measure. Meaning PrevyearTotal is zero then don't show value.

[@SabarishS95]

Hi Can you share the dimdate table creation video link?

[@AnalyticswithNags]

Here is the link... kzbin.info/www/bejne/eJ_UpXWufMeiZq8

[@SabarishS95]

@@AnalyticswithNags thanks

[@VinodKumar-zn8ty]

Hello Sir, In DIMDATE table as we created the dates manually.... what is the start date and end date need to choose here sir... As sales table has dates from 2016 jan to 2018 dec..... so same dates we need to create in DIMDATE table

[@AnalyticswithNags]

yes

[@sirichandana5909]

How did we get the quantity 6?

[@rajarshimaity6838]

Hello, when i recreated the same scenario i am facing an issue. my sales quantity MTD measure when i drag it to the chart it is coming as blank. Sale Qty MTD = TOTALMTD(sum(Sales[Quantity]),Calender_Lookup[Date].[Date]) relation between the sales and calender_lookup is also established. when i remove the date hierarchy and place year, month name and day column to the chart then this sales quantity MTD measure doesn't evaluate. when i add date itself, the measure works like a charm. is this happening because i selected .[Date] in the measure formula but in the chart it is Day, month name and year and no Date as a column under the Value section. i am unable to figure out the reason. Could you please help explain why it is happening ?

[@AnalyticswithNags]

To understand what does . Date does, watch this video kzbin.info/www/bejne/hoGVZKqpba1jjqc then you will understand what is going wrong

[@rajarshimaity6838]

@@AnalyticswithNags The doubt was clear. Thank You.

[@devopsworld8357]

Hi na, one doubt here why you did not use calculate function?

[@AnalyticswithNags]

These functions doesn't require.

[@ramakrishnapentyala4201]

sir i tried using MTD = CALCULATE([Total sales],DATESMTD(financials[Date])) then it gave the different answer when i did with MTD1 = TOTALMTD([Total sales], financials[Date].[Date]) what is the difference between these two measures

[@AnalyticswithNags]

In the below video ,the difference between totalytd and datesytd are explained. kzbin.info/www/bejne/d3fckoyOabKhrck Same difference applicable for Mrs as well

[@akshaykalamkar1545]

Very nice

[@AnalyticswithNags]

Thanks keep learning

[@williamstan1780]

Dear Nags I have problem in getting the accurate TOTALMTD and I believe it got something to do with my dimensions date table which is end on 31st Dec 2021 while I am trying to get the TOTALMTD for 9th Aug 2021, as it only works for TOTALYTD, but not TOTALMTD nor TOTALQTD. I tried to add the filter e.g. TotalMTD(EXPRESSION, calendar(date), filter (calendar, calendar(date)

[@AnalyticswithNags]

Restrict date table with the fact date

[@williamstan1780]

@@AnalyticswithNags tks

[@raghumajji2685]

Dear Sir...Could you please share the sample data ? so that we can practice.

[@AnalyticswithNags]

Check in description

[@raghumajji2685]

@@AnalyticswithNags Thank you

[@waseemalam9649]

I'm not able to find Sales Quantity Option in DAX Formula

[@AnalyticswithNags]

You need to write

[@sivakumarnerella4942]

@@AnalyticswithNags HELLO SIR IM NEW TO THIS. can you please tell me how to write sales quantity in this dataset

[@deepakdutt9722]

hi sir why we used dimdate table i did not understand that can you please explain requesting you.

[@AnalyticswithNags]

Dimdate is used for all Timeintelligence function. watch next 10 videos from relationship video in the complete playlist. Relation ship video kzbin.info/www/bejne/qJXWlKl-qcqUedk Complete Playlist kzbin.info/aero/PLjNd3r1KLjQt0xN_y8F6BSIOVNvdQmq4d

[@vishnuvardhanreddypulikant3419]

Hi sir, actually my requirement is let's say we have a Country and Year&Month slicers, when i select India it should take the FY as 1st Apr to 31st March and when i select US it should take the their country financial Year.So that the year end date should change dynamically in the TotalYTD DAX or DatesYTD DAX, so is that possible? So can pls do the video on this ASAP in the next week before 31st Dec 2020 if possible for u? Could you please let us know how we can do this??

[@AnalyticswithNags]

Usually Financial year is Fixed for Business. It seems like Interview tricky Question. My suggestion is, If you have country dimension table add the Financial Year end column against each country. In DAX YTD measure , Use variable to get the Financial year end based on country selected. Then use this variable in the YTD DAX calculation at Financial year end. Try this. If time permits i will make one video on this

[@rajeswarynadarajan1528]

Hi naga..have you done video for this query? Might be helpful for me also

[@danishkhatik3955]

Just watch previous video 😂😂😂😂 that set

[@AnalyticswithNags]

Not sure what you are talking about

[@sivasankar-xy8jl]

I have 2017,2018,2019,2020 sales i want calculate only 2018 sales how can do in dax.

[@AnalyticswithNags]

Check this video kzbin.info/www/bejne/i5TGfpqdq71letk

[@sesslynj3718]

Dim date is not present in data source sheet. Can you please provide DIM DATE sheet also ?

[@AnalyticswithNags]

kzbin.info/www/bejne/eJ_UpXWufMeiZq8

[@venkateshthammisetty7845]

Hi Sir, is it possible to give year end date dynamically in TotalYTD DAX instead of fixed like(4/30), so can u pls help me with this if there is a way

[@AnalyticswithNags]

Yes. You can use variable in that year end date and variable should be dynamiCally get the value

[@venkateshthammisetty7845]

@@AnalyticswithNags ,if possible can u pls do that video on that pls, it will help us many people or ping the measure here how it can be.

[@AnalyticswithNags]

Sure will do in coming weeks

[@venkateshthammisetty7845]

thanks

[@venkateshthammisetty7845]

Hi sir, actually my requirement is let's say we have a Country and Year&Month slicers, when i select India it should take the FY as 1st Apr to 31st March and when i select US it should take the their country financial Year.So that the year end date should change dynamically in the TotalYTD DAX or DatesYTD DAX, so is that possible? So can pls do the video on this ASAP in the next week before 31st Dec 2020 if possible for u?

[@hiteshjoshi3148]

Hello sir, Earlier there was a dedicated playlist for time intelligence functions and now there is none please make that again

[@AnalyticswithNags]

sure will try

[@sriramakrishna0215]

can you plz do on a video of LTM last twelve months if i click on 2016 march it shown (2016 march - 2015 april) if i click 2017 November then the measur have to show last 12 months from 2017 nov like (2016 dec-2017 nov) plz do thevideo on this task

[@AnalyticswithNags]

Answer in this video kzbin.info/www/bejne/nnuvgHWso8SZbs0

[@mohammedaltaf4877]

Good Work

[@AnalyticswithNags]

Thank you! Cheers!

[@surendhar3468]

Hi, can you share your all 50 DAX videos. Here, only have 16 videos.

[@AnalyticswithNags]

Keep watching the channel we will upload

[@surendhar3468]

@@AnalyticswithNags thank you sir

[@surendhar3468]

Sir, how can I get that dimdate table

[@AnalyticswithNags]

kzbin.info/www/bejne/eJ_UpXWufMeiZq8 this video contains DimDate creation

[@maddruleu]

Hello sir, I am getting error while entering DimDate, as if it is not a key command in powerBI

[@AnalyticswithNags]

Explore the similar problems here, learn.microsoft.com/en-us/answers/

[@prathyushapammi7353]

can you share the ppt's with us

[@AnalyticswithNags]

No. Ppt will not be shared

[@dellcis2335]

where can find DimDate because it is not exist in the dataset

[@AnalyticswithNags]

kzbin.info/www/bejne/eJ_UpXWufMeiZq8

[@waseemalam9649]

sum of Total 6555 is showing in every Row of Month. Please help

[@AnalyticswithNags]

Relationship missing

[@pravinwanve195]

How to calculate WTD????

[@AnalyticswithNags]

No direct function. Will take the video soon

[@GopiKrish895]

Can anyone explain why are you using DimDate[Date].[Date] in all measure. I m not able to use it in. when I try to type it, it shows error. Can someone explain. He said he will do a separate video for this. If you can pls share it

[@AnalyticswithNags]

Here is the link to the separate video on .date What is .Date of Date Column in DAX Calculation | Power BI Tutorial (50/50) kzbin.info/www/bejne/hoGVZKqpba1jjqc

[@GopiKrish895]

@@AnalyticswithNags Thank you

[@adesh74]

why are you using .Date in the end ? Confusing

[@AnalyticswithNags]

It is to refer the date column

[@ducmanhdo9927]

i don't know why my PBI don't permit to type Dimdate[Date].[Date] , it's only show Dimdate[Date]. and it also not cumulative :(( (I'm using Tabula model and Dimdate[Date] as date table )

[@AnalyticswithNags]

Watch the video relate to .date in channel

[@SrinivasEnkathala]

I'm getting error while I'm writing Dimdate[date].[Date],,,, error is: Column reference to 'DateKey' in table 'DimDate' cannot be used with a variation 'Date' because it does not have any.

[@AnalyticswithNags]

Explore the similar problems here, learn.microsoft.com/en-us/answers/

[@SaiSameerKulkarni]

Content is amazing. But its not clear. Its not legible after zoom in also. Kindly improve it quality so as to share to more people.

[@AnalyticswithNags]

Noted

[@rdcreations1078]

Dimdate option isnt available

[@AnalyticswithNags]

Refer Our Date table Video kzbin.info/www/bejne/eJ_UpXWufMeiZq8

[@shrikantbadge3978]

What is DIm ? What is DimDate? What is Month & MonthNO, Quarter & QuarterNo?

[@AnalyticswithNags]

kzbin.info/www/bejne/eJ_UpXWufMeiZq8

[@kevin-if9lr]

Sir, please share the dimdate excel file or explain about this - because i stuck here right now, help me sir!

[@AnalyticswithNags]

kzbin.info/www/bejne/eJ_UpXWufMeiZq8

[@monishsreenivas]

What kind of video, you have uploaded incomplete video. I suggest you to post complete video in one

[@AnalyticswithNags]

Thanks for suggestion

[@Nrgblocks_by_Nileshgavhane]

Measure not understood in MTD QTD YTD basically

[@AnalyticswithNags]

I don’t understand your question

[@neelimamoparthi121]

hello sir, im getting mtd value is blank

[@AnalyticswithNags]

Mtd alwayd shows the latest month value I think...so populate till current month and try. Otherwise you hav not used proper date column in MTD measure

[@mukkalavanya6013]

@@AnalyticswithNags I am showing the same how to do this

[@balachandruduganna]

Please send me really work project video

[@AnalyticswithNags]

check playlist

[@TwoMinutesisEnough]

Second question is not clear

[@vishalmane3139]

dataset is wrong

[@creed908]

the problem here is , The number of this video is 6 and the date dim table link is 13....🥲🥲 and the data i got , the table names are - Data, product master and sheet1 but the data here is different 🥲🥲🥲

[@AnalyticswithNags]

sure, will check on this mistake

[@amLife07]

Thank you so much Sir