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: ua-cam.com/video/ALldYA9LIE0/v-deo.html
Ata paryant evdhe clear explanation koni dile nhavte thanks for this video dada..
glad to see such comments 😍
Actually, your way of explanation is simple & easy to understand.
Thanks
Wow, this was so well done. Excellent explanations! Thank you for your efforts!
Good Job, beneficial for beginners.
Thank you Sir. Very helpful video.
Thank u sir, make more videos on dax.
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 very much Sir..... Very Helpful session.
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
Nice explanation!!!! Sir .very helpful
😍
Explanation is really good, suggestion please don't add music behind.
easy as pie, thanks
please provide a data set in the description box so that we can download the data set and practice whats been explained
Easy to understand
Thanks 🙏🏼
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
Can you please share the dataset used in this video so we can practice?
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
best session
super cool
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: ua-cam.com/video/ALldYA9LIE0/v-deo.html