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
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: th-cam.com/video/ALldYA9LIE0/w-d-xo.html
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
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 😍
Wow, this was so well done. Excellent explanations! Thank you for your efforts!
Explanation is really good, suggestion please don't add music behind.
Good Job, beneficial for beginners.
please provide a data set in the description box so that we can download the data set and practice whats been explained
Subscribed! Well played sir, well played.
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
Thank you very much Sir..... Very Helpful session.
Nice explanation!!!! Sir .very helpful
😍
Easy to understand
Thanks 🙏🏼
Please provide dataset for practice
super cool
best session
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
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: th-cam.com/video/ALldYA9LIE0/w-d-xo.html
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 ❤️
easy as pie, thanks
Thank u sir, make more videos on dax.
Thank you Sir. Very helpful video.
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
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
Can you please share the dataset used in this video so we can practice?
Bro ur explanation is so clear and to the point, u bring out the most required important portion! Great work Bhai!
dhanyavad 🙏🏼