Plz make Video for below Formula "Power Query", Video Time Fram is Max 10mint 1. List.RemoveMatchingItems 2. List.ReplaceMatchingItems 3. List.TransformMany 4. List.ReplaceValue 5. List.PositionOfAny 6. List.PositionOf 7. List.NonNullCount 8. List.Intersect 9. List.Durations 10. List.Difference 11. List.FindText 12. List.InsertRange 13. List.Union
Hey loved your video, but I have a problem of mine. I want to make slicer which should show date_range for last 3 months, last 6 months, last 9 months and last 12 months from the date column given. Please help how do I do that? I tried creating a date_range column using switch and If in Dax but it only shows 2 of them(i.e last 3 months and last 6 months even though I have data for last 9 and 12 months too. Would love to hear from you! Thanks
can you please make a video on how to combine outputs of multiple if statements based on different columns and we need to get the final output in a different column
Hi, I have a question " Query:IIF(ltrim(rtrim(upper(CallType))) NOT IN ('CG') And ltrim(rtrim(upper(Status)))='REI' And NOT((ltrim(rtrim(Homephone))='' OR Homephone IS NULL) And (ltrim(rtrim(Busphone))='' OR Busphone IS NULL)) ,1,0) As OPT_REI " this is SqL Query, how to write in DAX??
hi, I really learn a lot with your tutorials, but i can´t figure out how to manage in if statements for power bi to differentiate blanks from zero. i have this formula.... IF('Raw Data'[FTYiT]
am Preparing Profit center wise chart. I have Two Table Header Table and Line item Table Header table having information about Invoice No, Invoice Date, Document Type ( like Cash Invoice, Advance Sales, Sales Return) Line item table Invoice num, item number, name, item amount, Qty, Profit center. Now am taking total sales values from Line item values by profit center but here if sales return and Advance amount to reduced from total how can do this scenario, can we do if statement
Hi Sir, Good idea to structorate nested ifs in tree its give more tracebility. Question : If i need to incorporate in nested ifs AND , OR statements. For DAX usage (logic) will be the same like in excel?
Plz make Video for below Formula "Power Query", Video Time Fram is Max 10mint
1. List.RemoveMatchingItems
2. List.ReplaceMatchingItems
3. List.TransformMany
4. List.ReplaceValue
5. List.PositionOfAny
6. List.PositionOf
7. List.NonNullCount
8. List.Intersect
9. List.Durations
10. List.Difference
11. List.FindText
12. List.InsertRange
13. List.Union
That was helpful, I would have loved to see an example with.... if Salary is between....or > 50 and
Hey loved your video, but I have a problem of mine.
I want to make slicer which should show date_range for last 3 months, last 6 months, last 9 months and last 12 months from the date column given. Please help how do I do that?
I tried creating a date_range column using switch and If in Dax but it only shows 2 of them(i.e last 3 months and last 6 months even though I have data for last 9 and 12 months too.
Would love to hear from you! Thanks
Hi! Silly question. Do we have to use the SUM() function inside the IF. Can we just compare the value of the Salary alone. Thnx in advance
can you please make a video on how to combine outputs of multiple if statements based on different columns and we need to get the final output in a different column
how do I use the if statement on Power Bi if there is greater than and less than
Hi, I have a question " Query:IIF(ltrim(rtrim(upper(CallType))) NOT IN ('CG') And ltrim(rtrim(upper(Status)))='REI'
And NOT((ltrim(rtrim(Homephone))='' OR Homephone IS NULL) And (ltrim(rtrim(Busphone))='' OR Busphone IS NULL))
,1,0) As OPT_REI " this is SqL Query, how to write in DAX??
Hi, I have question, How about "if more than and not less than" if i want to put inside the Power BI?
hi, I really learn a lot with your tutorials, but i can´t figure out how to manage in if statements for power bi to differentiate blanks from zero. i have this formula.... IF('Raw Data'[FTYiT]
I found that really useful, thank you!
am Preparing Profit center wise chart.
I have Two Table Header Table and Line item Table
Header table having information about Invoice No, Invoice Date, Document Type ( like Cash Invoice, Advance Sales, Sales Return)
Line item table Invoice num, item number, name, item amount, Qty, Profit center.
Now am taking total sales values from Line item values by profit center but here if sales return and Advance amount to reduced
from total
how can do this scenario, can we do if statement
how can I get rid of the result of IF Statement in TOTAL ?
Hi Sir, Good idea to structorate nested ifs in tree its give more tracebility. Question : If i need to incorporate in nested ifs AND , OR statements. For DAX usage (logic) will be the same like in excel?
CAN YOU PLEASE TELL ME HOW CAN I USE IF STATEMENT WITH STRING OR IF THERE IS ANOTHER WAY OR FUNCTION THAT CAN REPLACE IF STATEMENT TO USE WITH STRING?
You can use the IF statement with strings. Let me know where you're getting stuck
@@BIElite getting stuck when comparing values in a column to another with text values like "@5c@"
With another column "@5d@"
If both are same it has to print " ok"
Else go to next if condition
But now in powerbi I am getting if then else if
Else
Etc
This is not working now
How do you compare values across multiples and return a custom value as result.
Hi soji, could you give me some more details on what you're trying to accomplish?
Is it possible to create this IF statement using a value from a slicer?
Thanks from my side for your mini tutorial! Hope you continue to help others!
Haha thanks socrates!
Very Helpful. Thank you!
Thanks Eric!