Chart with last 4 weeks' data and secondary chart with just last week's data
Hello! This is my first forum post so please be understanding if I post too much info, I want to be 'easy' to help 🙂 I am trying to show 4 weeks of data in a chart, which is easy, but on the same power bi page in a different chart, show the most recent week worth of data too. I have the data automatically uploading from a database source. The data I have currently looks like this in my query, with the current chart showing the equipment name on x axis, and the OEE percentages on Y. There is a slider that is linked to Shift ISO column so that the last 4 weeks of data can be displayed. Is there any way to make a chart that only shows the last week's worth of data based on the time of accessing the power bi? thank you!Power BI Dax? - Subtract from Running Total Power Query, if statement, new measure or quick measure
I am trying to see what is the easiest way to do a running subtraction. If statement, new measure or quick measure in Power Bi Dax Sales Qty is 1.2 million (1,200,000) for each order. See table attached. I want to subtract for every order from the available qty so the Available Qty decreases for every new order listed with the same part. Available Qty" should 5,390,000 --> 4,190,000 --> 2,990,000 --> 1,790,000, --> 590,000, --> -610,000, --> -1,810,000 etc. Would like to do this in Power Query, if statement, new measure or quick measure if possible? My goal is to get a new Column Created Called "Actual Available Qty" should 5,390,000 --> 4,190,000 --> 2,990,000 --> 1,790,000, --> 590,000, --> -610,000, --> -1,810,000 etc.
Copy value from one row to underlying rows
Hi all ! I have searched for a solution to this problem without luck - hopefully this issue is known to others: I have a table with date and transactions. The problem is that the date is not repeated on the rows - see example below. I am looking for the soluttion to copy the date and replace the "null" with date - until a new date is reached: My table: This should read: Thankful for any hint and suggestions ! Rgds Eirik B
Changing Data through slicer
I would like to create new data based on a slicer setting i have chosen linked to a parameter values. For example, i have a baseline monthly forecast for 2022. I would like to apply a percentage change to this baseline forecast for alternative scenarios. For instance, i want to see what the forecast looks like if it was 5% higher than the baseline forecast. I need this at the data column level and not a measure so that i can create some formulas off that new column data. For instance, if column B is the baseline forecast, I have create a new column that equals the baseline forecast column multiplied by (1+ parameter value); in this case, i set my slicer to 5%. I could have easily chosen 6% or something else, that's the type of functionality I'd like to build.   I have created a measure that works visually for this, but i realized I really need this at the column level to use it for other things the way I want. Adjusted Forecast = 'sheet1'[Baseline Forecast]*(1+'Adjustment Parameter'[Adjustment Parameter Value]/100)Expressions that yield variant data-type cannot be used to define calculated columns.
Hey Guys BIZ DATE = if(and(Format([ATD],"")=blank(),format([BIZ DAYS],"")=blank()),"", var dateidx = calculate( max('Calendar'[WorkingDayIndex] ) , 'P FILES'[ATD] = RELATED('Calendar'[Date] ) ) var newdateidx = dateidx + 'P FILES'[BIZ DAYS] return calculate( max('Calendar'[Date]), filter( ALL('Calendar'), 'Calendar'[WorkingDayIndex] = newdateidx && 'Calendar'[IsWorkDay] = 1 ) ) ) Data is company sensetive. I found a forum that suggested creating a calendar table to add days to a date and that seems to work (everything after the first line). However, the if statement will not seem to work. I understand that I am looking at two columns with different formatting (one is date and the other is text) I have tried using several combinations of value and format functions to no avail. I cannot change the formatting of these columns as their formatting is necessary for other calculated columns. I have tried making helper columns a little, but haven't had much luck. Also, the ATD column, which is date format, has blanks (null) in it. Any suggestions are appreciated. -Tad
