Sir I would like to have a one on one session with u sir.... I would like to know all dax formulas for measure, columns with real time scenarios sir like main formals which used for projects in job.... Basic to advance scenarios for dax formulas and where to use... What is the use of each formal with definition why to use ,when to use etc.
Hello, If it is something that you want to discuss in detail then you can book a session with me as per your requirement from the below link: topmate.io/learnwidgiggs
Hi Shashank. Can you please guide how to practice dax like for sql we have so many questions to practice ..we have leetcode..what should be our approach to practice dax for a fresher
I faced one question during interview ther is a table with lot of columns , the requirement is to write a dax to create a table which will give a table with only 3 columns and with conditions . the column name with conditions are: 1. product id (should be less than equal to 100) , 2.product name( should start from s) and 3.product price (should be greater than equal to 500) . Shashank sir can u suggest the dax for this .
Creating DAX Table with Conditions  write a dax to create a table which will give a table with only 3 columns and with conditions. the column name with conditions are: 1. product id (should be less than equal to 100), 2. product name(should start from s) and 3. product price (should be greater than equal to 500). =SUMMARIZECOLUMNS( FILTER( ALL('Table'), 'Table'[Product ID] = 500 ) Please note, it is assuming that the table name is 'Table' and the column names are 'Product ID', 'Product Name' and 'Product Price'. Please replace with the corresponding table and column names in your actual data. Try to make it correct😅😅
There is no Specific dax formulas used in every project, it depends on scenario to scenario...rather I can tell you the DAX functions commonly used and few common scenarios..for which you can book-"Career Guidance in Data Analytics"
If we have two fields sales and target and we want to show for which product sales reached target and for which product it didnt reached which visual we should use ?
Do agile methodology use in companies to complete project's. Can u make one videos on this or explain here that what is agile methodologies what is scrum calls bla bla
excellent in nutshell, thanks
Sir, Please explain use of Pie and donut chart .
Sir I would like to have a one on one session with u sir.... I would like to know all dax formulas for measure, columns with real time scenarios sir like main formals which used for projects in job.... Basic to advance scenarios for dax formulas and where to use... What is the use of each formal with definition why to use ,when to use etc.
Hello, If it is something that you want to discuss in detail then you can book a session with me as per your requirement from the below link: topmate.io/learnwidgiggs
Finished watching
Hi friend, one interview question, how can we make a single DAX show YTD, QTD, and MTD altogether
Hi Shashank. Can you please guide how to practice dax like for sql we have so many questions to practice ..we have leetcode..what should be our approach to practice dax for a fresher
What is commonly used power bi service or power bi report server ?
Power BI Service
Excellent explanatio
Glad you liked it 😊
can we get this dataset to practice
I faced one question during interview ther is a table with lot of columns , the requirement is to write a dax to create a table which will give a table with only 3 columns and with conditions . the column name with conditions are: 1. product id (should be less than equal to 100) , 2.product name( should start from s) and 3.product price (should be greater than equal to 500) . Shashank sir can u suggest the dax for this .
Noted, I will coverup in a video as I have to test it first what I am thinking off as a solution...may I know in which company it was asked ?
@@learnwidgiggs Deloitte
Creating DAX Table with Conditions

write a dax to create a table which will give a table with only 3 columns and with conditions. the column name with conditions are: 1. product id (should be less than equal to 100), 2. product name(should start from s) and 3. product price (should be greater than equal to 500).
=SUMMARIZECOLUMNS( FILTER( ALL('Table'), 'Table'[Product ID] = 500 )
Please note, it is assuming that the table name is 'Table' and the column names are 'Product ID', 'Product Name' and 'Product Price'. Please replace with the corresponding table and column names in your actual data.
Try to make it correct😅😅
@@rakeshbahekar Great
@@learnwidgiggs Sir, We can user Selectcolumns Dax function
In waterfall chart we make breakdowns also right
Yes we can
In topmate there is no option for dax formulas used in real time projects so then which amount should I pay
There is no Specific dax formulas used in every project, it depends on scenario to scenario...rather I can tell you the DAX functions commonly used and few common scenarios..for which you can book-"Career Guidance in Data Analytics"
5:01 even having positive linear regression
If we have two fields sales and target and we want to show for which product sales reached target and for which product it didnt reached which visual we should use ?
Gauge visual
Thank you so much for the video sire
My pleasure
Very useful 👍
Glad to hear this 😊
Hii good morning sir can we migrate report from tableau to power bi
And how can we do it pls if possible make video or guide me sir pls
I don't think we can migrate.
@@learnwidgiggs we can do it sir
Then I am not aware about it how we can directly migrate from tableau to power bi, plz google it or ask some other person.
Thanks man!
Welcome 😊
Thank you sir 🙏
Most welcome!
Is power bi have future scope
Big Yess
What was the charges sir
sir ap interview preparation karbate ho
Haa, you can book a session from here: topmate.io/learnwidgiggs
Sir can u see linkdln I have texted clearly
Do agile methodology use in companies to complete project's. Can u make one videos on this or explain here that what is agile methodologies what is scrum calls bla bla
Noted.
@@learnwidgiggs please explain this in respect of PowerBI only
Please make video... I'm waiting for video...u said noted ... please make video bro...
off topic: do u have any idea how to resolve OracleOraDB21Home1TNSListener isn't running issue.
Nope, sorry
Any finance domain related project explaination