Hi Satyajit,thanks a ton for the video,just one suggestion the time intelligence functions are not that clear,seems like you rushed throught it. If you did the last one same as previous it would be great,like in TOTALYTD there are 4 values,what are those,how can we change the 2 value,all that thing. Maybe i am new in power bi that's why i felt so just saying.Thanks
i have a question I have data ytd , MTD,QTD LAST YEAR, MY REQUIRMENT IS WHEN I SELECT ANT DATA RANGE 1) IT SHOULD SHOW TODAY -1 ,2) YTD -ALSO TODAY -1 AND IF A NEW YEAR STARTS (I MEAN JAN 2025) I SHOULD SHOW 2024 1-JAN TO 31DEC,SAME LIKE QTD ONCE A NEW QUATER STARTS THE PREVIOUS QUATER DATE SHOULD REFLECT (LAST QUATER 1ST TO LAST DATE IF DAY IS APRIL1ST) SAME LIKE MTD CAN U PLEASE EXPLAIN THIS
Hi Satyajit, I have a questions to you, well can I calculate two columns in power bi, having different data types each, basically want to filter the data, based on some criteria. Hope to get an answer from you. Thanks!
Cool. Problem with CALCULATE is that its very easy to be misunderstood. Truth is that CALCULATE can be rewritten using FILTER(ALL()) AND it can among other things REPLACE External filters on the same filtered column or ADD if CALCULATE and EXTERNAL filters are different. It can also change context from ROW CONTEXT to FILTER CONTEXT ... resource: ruclips.net/video/ALldYA9LIE0/видео.html
![[[ 1 HOUR ]] Complete Power BI DAX End to End - Power BI DAX Tutorial - Full Course by Satyajit](/img/1.gif)
Wow, this was so well done. Excellent explanations! Thank you for your efforts!
Actually, your way of explanation is simple & easy to understand.
Thanks
Ata paryant evdhe clear explanation koni dile nhavte thanks for this video dada..
glad to see such comments 😍
Good Job, beneficial for beginners.
Subscribed! Well played sir, well played.
Bro ur explanation is so clear and to the point, u bring out the most required important portion! Great work Bhai!
dhanyavad 🙏🏼
Thank you Sir. Very helpful video.
Thank u sir, make more videos on dax.
Thank you very much Sir..... Very Helpful session.
Nice explanation!!!! Sir .very helpful
😍
Hi Satyajit,thanks a ton for the video,just one suggestion the time intelligence functions are not that clear,seems like you rushed throught it.
If you did the last one same as previous it would be great,like in TOTALYTD there are 4 values,what are those,how can we change the 2 value,all that thing.
Maybe i am new in power bi that's why i felt so just saying.Thanks
I have a full 1.5 hrs video on DAX, go through it
please provide a data set in the description box so that we can download the data set and practice whats been explained
Explanation is really good, suggestion please don't add music behind.
easy as pie, thanks
Can you please share the dataset used in this video so we can practice?
best session
Easy to understand
Thanks 🙏🏼
super cool
i have a question I have data ytd , MTD,QTD LAST YEAR, MY REQUIRMENT IS WHEN I SELECT ANT DATA RANGE 1) IT SHOULD SHOW TODAY -1 ,2) YTD -ALSO TODAY -1 AND IF A NEW YEAR STARTS (I MEAN JAN 2025) I SHOULD SHOW 2024 1-JAN TO 31DEC,SAME LIKE QTD ONCE A NEW QUATER STARTS THE PREVIOUS QUATER DATE SHOULD REFLECT (LAST QUATER 1ST TO LAST DATE IF DAY IS APRIL1ST) SAME LIKE MTD
CAN U PLEASE EXPLAIN THIS
why did you use "= =" for calculate? can anyone explain?
can u tell me the exact time in video to check?
4:55@@SatyajitPattnaik
@@suhasinisatishg thats how it works
i mean why not single = sign? why == ? @@SatyajitPattnaik
Please provide dataset for practice
how to get data
Hi Satyajit,
I have a questions to you, well can I calculate two columns in power bi, having different data types each, basically want to filter the data, based on some criteria. Hope to get an answer from you. Thanks!
+1
Can you provide dataset in the description plz
Go to the full DAX video and the datasets are provided in that video..
Thank you bro. Keep going ❤️
Cool. Problem with CALCULATE is that its very easy to be misunderstood. Truth is that CALCULATE can be rewritten using FILTER(ALL()) AND it can among other things REPLACE External filters on the same filtered column or ADD if CALCULATE and EXTERNAL filters are different. It can also change context from ROW CONTEXT to FILTER CONTEXT ... resource: ruclips.net/video/ALldYA9LIE0/видео.html