Showing old existing/latest data until there's a new data uploaded
Hello everyone, i have problem to show any data that appeared on July 22nd and July 30th. How to add a function that can show existing data in date slicer selection (like if on July 23rd until July 29th there's no data uploaded, data from July 22nd still shown). Until new data uploaded, only latest data shown. Is there any DAX that can i implement? like creating ins_true tabe colum with TRUE/ FALSE boolean data type or anything else? Thanks. PS: the "issue_progress" is a Text/string data type
Column value change based on matrix hierarchy
Hello, I have a matrix visualization that utilizes a hierarchy. I also have a target value that changes based on the hierarchy. What DAX should I use so that the value changes in accordance with the hierarchy? The top line visual looks like this: Supply Chain MTD YTD Target GSC 76.7% 76.7% 75.9% PSM 79.5% 79.5% 76.9% And then the drill down looks like this: Product Site MTD YTD Target GSC A RV 100.0% 100.0% 70.0% A UM 50.0% 50.0% 75.0% A BC 72.4% 72.4% 70.0% PSM P BC 55.6% 55.6% 70.0% P W 47.6% 47,6% 70.0% P I 53.3% 53.3% 70.0% Note that the target for each supply chain has one value, and then those targets change again depending on the combination of product and site. Ideally, I'd be able to conditionally format the MTD value depending on whether it was more or less than the target.
