Explode and duplicate Rows
Dear all, I have a little problem on Power Query, In fact, I integrated TABLE1 from an Excel file and in Power BI and I want to transform the table and explode it according to the number of days off (by modifying the date each time of END) as shown below. there is any solution to do it in Power Query PBI?DrillDown issues with different time and value metrics
Hello! Ive been having some issues visualizing in a drill down from the quarters of a year to the months: I have a metric named, # of Backlog Unscheduled Cases (End of Month) that i have to use it in the axis with the time metric (month). The same for, # of Backlog Unscheduled Cases (End of Quarter) but with the time metric quarter. Ive been using this formula cause i want to put these 2 different values ina line chart so i have each metric matched with time metric that correspond. The issue is when i want to see the months because when I make a drill down to see the data divided by months, I just see the data of the beginning of every quarter. For example (month 1, month 4, month 7, month 11). I would like to see the data of the Twelve months(Ive checked the month metric separatedly and it works i visualize all the months, maybe its the formula). Here is a screenshot: ChangeInDrillDown = VAR month1 = 'Fact - Backlog Cases'[# of Backlog Unscheduled Cases (End of Month)] VAR quarter1 = 'Fact - Backlog Cases'[# of Backlog Unscheduled Cases (End of Quarter)] RETURN IF(ISFILTERED('Hierarchy - Fiscal Calendar on Open Date'[FiscalYear]),month1,quarter1)
