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

Подписаться 107 тыс.

Просмотров 153 тыс.

50% 1

How to Calculate Year to date (YTD) calculations in DAX / Power BI
How to calculate Quarter to date (QTD) calculations in DAX / Power BI
How to Calculate Month to date (MTD) calculations in DAX / Power BI
What is YTD, QTD, MTD
How to Calculate MTD QTD YTD in DAX / Power BI
Power BI DAX Tutorial with Examples
#powerbi #powerbidax #dax #MTD #YTD #QTD
Datasource Link
drive.google.com/file/d/1lTaf...
DimDate Table
• How to Create Date Tab...
✉ Business Queries / Analytics Consulting ✉ : analyticswithnags@gmail.com
💬 For Learners Post queries and Interact 💬 : t.me/analyticswithnags
Complete Playlists
Power BI Tutorials - Complete Playlist 📚📖 • How to do Power BI Ins...
Power BI Desktop Tips and Tricks 📚📖 • How to Remove Top N ro...
Power BI DAX - Complete Playlist 📚📖 • What is DAX in Power B...
Power BI Project Dashboards - Power BI Realtime Projects - Playlist 📚📖 • Loan disbursement Anal...
Power Pivot 📚📖 • Power BI Tutorial (15/...
Power Query 📚📖 • Power BI Tutorial (15/...
Power BI Services Playlist 📚📖 • Introduction to Power ...
Power BI Tamil Tutorials 📚📖 • How to do Power BI Ins...
Power BI Telugu Tutorials 📚📖 • How to do Power BI Ins...
SQL Full Course | SQL Tutorial For Beginners 📚📖 • Learn SQL Complete | C...
SSAS Tutorials - SQL Server Analysis Services 📚📖 • Introduction to SQL Se...
MSBI Tutorials - SQL + SSAS + SSIS 📚📖 • Learn SQL Complete | C...
Data Analyst - Complete Reference - Playlist 📚📖 • Data Analytics For Beg...
BI Developer - Complete Reference - Playlist
📚📖 • Power BI Tutorial From...
BI Architect - Complete Reference - Playlist
📚📖 • Power BI Full Course -...
ETL Developer - Complete Reference - Playlist 📚📖 • Building an Enterprise...
Database Developer - Complete Reference - Playlist 📚📖 • SQL Tutorial - Full Da...

Наука

Опубликовано:

26 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 201

@mangkhongsai9029 7 месяцев назад

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 7 месяцев назад

Thanks keep learning. Share this channel with friends and colleagues

@AArora81 3 года назад

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

@AnalyticswithNags 3 года назад

Glad it was helpful! Keep learning and Sharing.

@mohijshaikh9057 Год назад

Great😃.. Today I have almost cleared the confusion of DAX by watching your 5 videos only.. thank you for the amazing content.., more to go...

@AnalyticswithNags Год назад

Thanks keep learning share this channel with friends and colleague

@newlifefoundation3917 3 года назад

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 3 года назад

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

@manoharkulat Год назад

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

@AnalyticswithNags Год назад

Thank you, I will

@irfandaud7380 2 года назад

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

@AnalyticswithNags 2 года назад

Thanks

@divyagand2580 2 года назад

simple but powerful tips. fiscal year tip was bonus.

@AnalyticswithNags 2 года назад

Thanks keep learning share this channel with friends and colleagues

@shrutisharma1434 2 года назад

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

@AnalyticswithNags 2 года назад

Thanks keep learning and share this channel with friends and colleagues

@shrutisharma1434 2 года назад

@@AnalyticswithNags sure 🙂

@manishlalsah8075 Год назад

Thankyou sir, All doubts are cleared.

@AnalyticswithNags Год назад

Always welcome

@YassirMirghani 25 дней назад

Great. Thank you

@mikeycbd 3 месяца назад

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

@AnalyticswithNags 3 месяца назад

Awesome, thank you!

@amLife07 16 дней назад

Thank you so much Sir

@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

@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

@user-qq5jq4yg6k 8 месяцев назад

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 3 месяца назад

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

@mahendharyadav2657 2 года назад

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

@AnalyticswithNags 2 года назад

Filter the fiscal year

@Ssinger123 2 года назад

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

@AnalyticswithNags 2 года назад

Soon will make video on this

@Ssinger123 2 года назад

@@AnalyticswithNags tqsm

@akashhanchatet-2842 3 месяца назад

Thank you sir 🙏🏻❤

@AnalyticswithNags 3 месяца назад

Most welcome

@adventuresofvyomandkeshav3036 2 года назад

thanku sir.very helpful

@AnalyticswithNags 2 года назад

Thanks keep learning share this channel with friends and colleagues

@krishnaskills7459 2 года назад

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

@AnalyticswithNags 2 года назад

sure

@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

@shivammishra-mk9jp 2 года назад

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 2 года назад

Watch end to end playlist

@GauravMishra-uo2fq 3 месяца назад

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 3 месяца назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-BnqtBxGbo0M.html

@erudition4788 3 года назад

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 3 года назад

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 2 года назад

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

@aiinabox1260 2 года назад

@@AnalyticswithNags super

@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

@patlollaakhila397 7 месяцев назад

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 5 месяцев назад

thank you , keep learning

@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

@shrutisharma1434 2 года назад

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 2 года назад

Soon I will make a video on this

@gaddesiva1549 2 года назад

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

@AnalyticswithNags 2 года назад

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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-BnqtBxGbo0M.html

@siribn2657 2 года назад

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 2 года назад

Use .date Dimdate[date].date

@poojapohani4536 2 года назад

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 2 года назад

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

@gaddesiva1549 2 года назад

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 2 года назад

Use If condition before measure

@shubhamyadav-ig8bi 9 месяцев назад

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

@AnalyticswithNags 3 месяца назад

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

@mohshalsh5965 2 года назад

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

@AnalyticswithNags 2 года назад

Soon will create video on this topic

@ramakrishnapentyala4201 3 года назад

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 3 года назад

In the below video ,the difference between totalytd and datesytd are explained. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-AFyaYX4Mnwg.html Same difference applicable for Mrs as well

@mohammedaltaf4877 3 года назад

Good Work

@AnalyticswithNags 3 года назад

Thank you! Cheers!

@sreekanth8395 2 года назад

THANKS NAG

@AnalyticswithNags 2 года назад

Thanks keep learning share this channel with friends and colleagues

@jyotidatta2126 2 года назад

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

@AnalyticswithNags 2 года назад

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

@rajarshimaity6838 2 года назад

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 2 года назад

To understand what does . Date does, watch this video ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-PP23ws8H0XE.html then you will understand what is going wrong

@rajarshimaity6838 2 года назад

@@AnalyticswithNags The doubt was clear. Thank You.

@bzflowerbee 3 года назад

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 3 года назад

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 3 года назад

@@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 RU-vid 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 RU-vid in case you are interested. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Q7jC1pEulis.html I'm looking forward to your video on the 445 calendar. Thank you again!

@rammohanreddy9014 4 года назад

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 4 года назад

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 4 года назад

@@nagendrakg5062 ok thank you

@AnalyticswithNags 3 года назад

Thank you

@abhishekawari919 2 года назад

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

@AnalyticswithNags 2 года назад

Check the video show data till selected month

@salidandigopi4358 2 года назад

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

@AnalyticswithNags 2 года назад

Watch this video ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-PP23ws8H0XE.html

@salidandigopi4358 2 года назад

Now I cleared , Thnak you so much

@vishnuvardhanreddypulikant3419 2 года назад

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 2 года назад

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

@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

@jaibalayya8853 2 года назад

very usefullllll

@AnalyticswithNags 2 года назад

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

@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

@williamarthur4801 2 года назад

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

@AnalyticswithNags 2 года назад

Check this out. What is .Date of Date Column in DAX Calculation | Power BI Tutorial (50/50) ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-PP23ws8H0XE.html

@hindi-english1664 2 года назад

what is the least difference between DATESMTD and TOTALMTD?

@AnalyticswithNags 2 года назад

Watch this video ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-AFyaYX4Mnwg.html

@venkateshthammisetty7845 3 года назад

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 3 года назад

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

@venkateshthammisetty7845 3 года назад

@@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 3 года назад

Sure will do in coming weeks

@venkateshthammisetty7845 3 года назад

thanks

@venkateshthammisetty7845 3 года назад

@nageshreddy8062 2 года назад

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

@AnalyticswithNags 2 года назад

Refer this. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-BnqtBxGbo0M.html

@sakibzamanmohammad8895 3 года назад

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 3 года назад

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

@swapnachilakam1684 21 день назад

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

@akshaykalamkar1545 2 года назад

Very nice

@AnalyticswithNags 2 года назад

Thanks keep learning

@sunnybhushan5210 Год назад

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

@AnalyticswithNags Год назад

Not sure about your question

@kalyanisri758 2 года назад

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

@AnalyticswithNags 2 года назад

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

@williamstan1780 2 года назад

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 2 года назад

Restrict date table with the fact date

@williamstan1780 2 года назад

@@AnalyticswithNags tks

@hiteshjoshi3148 Год назад

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

@AnalyticswithNags 3 месяца назад

sure will try

@SabarishS95 3 года назад

Hi Can you share the dimdate table creation video link?

@AnalyticswithNags 3 года назад

Here is the link... ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-BnqtBxGbo0M.html

@SabarishS95 3 года назад

@@AnalyticswithNags thanks

@sriramakrishna0215 2 года назад

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 2 года назад

Answer in this video ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-hJLOBvn_f8k.html

@deepakdutt9722 3 года назад

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

@AnalyticswithNags 3 года назад

Dimdate is used for all Timeintelligence function. watch next 10 videos from relationship video in the complete playlist. Relation ship video ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-rdscvHteaCw.html Complete Playlist ru-vid.com/group/PLjNd3r1KLjQt0xN_y8F6BSIOVNvdQmq4d

@devopsworld8357 2 года назад

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

@AnalyticswithNags 2 года назад

These functions doesn't require.

@sivasankar-xy8jl 3 года назад

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

@AnalyticswithNags 3 года назад

Check this video ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-UccMggvX2Dw.html

@maddruleu 9 месяцев назад

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

@AnalyticswithNags 3 месяца назад

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

@raghumajji2685 2 года назад

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

@AnalyticswithNags 2 года назад

Check in description

@raghumajji2685 2 года назад

@@AnalyticswithNags Thank you

@user-fl8rv7sg3v Месяц назад

your teachining great , can you provide datset link

@AnalyticswithNags Месяц назад

Thanks keep learning

@amritsinghania2722 2 года назад

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

@AnalyticswithNags 2 года назад

Watch the .date video on channel playlist

@user-ew1hi7sf2q 7 месяцев назад

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 3 месяца назад

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

@waseemalam9649 2 года назад

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

@AnalyticswithNags 2 года назад

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

@sesslynj3718 6 месяцев назад

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

@AnalyticswithNags 3 месяца назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-BnqtBxGbo0M.html

@GopiKrish895 8 дней назад

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 7 дней назад

Here is the link to the separate video on .date What is .Date of Date Column in DAX Calculation | Power BI Tutorial (50/50) ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-PP23ws8H0XE.html

@GopiKrish895 7 дней назад

@@AnalyticswithNags Thank you

@vinodkumarhs4000 2 года назад

How to calculate previous day dispatches?

@AnalyticswithNags 2 года назад

Use Dax dateadd function

@vinodkumarhs4000 2 года назад

@@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.

@surendhar3468 3 года назад

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

@AnalyticswithNags 3 года назад

Keep watching the channel we will upload

@surendhar3468 3 года назад

@@AnalyticswithNags thank you sir

@surendhar3468 3 года назад

Sir, how can I get that dimdate table

@AnalyticswithNags 3 года назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-BnqtBxGbo0M.html this video contains DimDate creation

@danishkhatik3955 Год назад

Just watch previous video 😂😂😂😂 that set

@AnalyticswithNags Год назад

Not sure what you are talking about

@rdcreations1078 3 года назад

Dimdate option isnt available

@AnalyticswithNags 3 года назад

Refer Our Date table Video ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-BnqtBxGbo0M.html

@dellcis2335 4 месяца назад

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

@AnalyticswithNags 3 месяца назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-BnqtBxGbo0M.html

@ducmanhdo9927 2 года назад

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 2 года назад

Watch the video relate to .date in channel

@kevin-if9lr 3 месяца назад

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

@AnalyticswithNags 3 месяца назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-BnqtBxGbo0M.html

@waseemalam9649 2 года назад

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

@AnalyticswithNags 2 года назад

Relationship missing

@adesh74 2 года назад

why are you using .Date in the end ? Confusing

@AnalyticswithNags 2 года назад

It is to refer the date column

@neelimamoparthi121 3 года назад

hello sir, im getting mtd value is blank

@AnalyticswithNags 3 года назад

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 2 года назад

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

@prathyushapammi7353 Год назад

can you share the ppt's with us

@AnalyticswithNags Год назад

No. Ppt will not be shared

@monishsreenivas 4 месяца назад

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

@AnalyticswithNags 4 месяца назад

Thanks for suggestion

@balachandruduganna 2 месяца назад

Please send me really work project video

@AnalyticswithNags 2 месяца назад

check playlist

@Nrgblocks_by_Nileshgavhane 2 года назад

Measure not understood in MTD QTD YTD basically

@AnalyticswithNags 2 года назад

I don’t understand your question

@pravinwanve195 Год назад

How to calculate WTD????

@AnalyticswithNags Год назад

No direct function. Will take the video soon

@shrikantbadge3978 9 месяцев назад

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

@AnalyticswithNags 3 месяца назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-BnqtBxGbo0M.html

@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

@creed908 3 месяца назад

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 3 месяца назад

sure, will check on this mistake