IF Statement using Power Query
Hello, I am trying to write an IF statement to capture the following dates. I have and excel spreadsheet withs millions of records. For one of the columns in my spreadsheet, I want to create a new column to capture all DT_SCHED (date field) prior to June 1, 2017 and return a "Delivery Date of June 1st" and if the DT_SCHED date is greater than June 1st but less than December 31st, I want my IF statement to return "December 1st" delivery date. Could anyone help me figure this out? I don't have the Power Query Add-In to do a conditional lookup but have attached a screenshot with my first attempt but apparently the formula is VERY WRONG :)
Current Month , Previous Month and Before Previous Month
HI PBI Experts , Here is my question for you in dax , i want to know the sales of the "current month", "last month", "last before month sales" by using the Dax. i am using previousmonth dax function and i want to know for current month , before previous month dax function. will give kudos Advance Thanks, Thanks sandeep
How to deal with null value and blank value in power Query ?
Hi guys, I am a green hand to use power BI, I am quite confuse about how to deal with null values or missing value in different type of value now , it will destory the data by filling down or fieltering out/deleting the null / blank row in some situations... for example those rating, status and department coloums, how should I handle them ? is there any post that include the situations about dealing different types of coloumn with null / blank value I can learn from it ? Many Thanks!New 'Enter Data' feature -- can we edit after creating table?
Hi, I am loving this new 'Enter Data' feature! My question is, after I have created a table using the 'Enter Data' feature --- is it possible to Edit that table? It does not seem like that is possible but I could be wrong. Anyone else used this feature yet? Thanks in advance!
