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)
DAX Largest Change from Previous month HELP
Hi team, I'm trying to create a visual that shows the top 5 variables in a specific column that experienced the largest change since the previous month. So as we add data on a monthly basis, I would like to show the largest 'movers' each time we refresh the data (on a monthly basis). The variables are string values. My inputs are the following measures I've created: Current Month = CALCULATE((COUNTROWS( 'CLIENT DATASET'))) Previous month Count CALCULATE( COUNTROWS('CLIENT DATASET') , PREVIOUSMONTH('CLIENT DATASET'[Time of Breach])) Difference = [Current Month] - [Previous month Count] When I apply the final Measure (Difference) to the variable in the table I want to analyse the monthly change (a column with string values, not numbers, but thats where i presume the [Current Month] measure comes in) and create a table visual out of it, I get the exact same output if I were to create a table visual with the variable against count per variable. Please help in informing me how im going about this problem in the wrong manner. cheersRelative Change
I'm trying to create a table which shows the top N entities that experienced the largest amount of change relative to the previous month (actual quantities or percentage change, doesnt matter). I have tried the following DAX query but it doesnt work because one of the columns carries string types. Measure = sum('CLIENT DATASET'[Model Breach])-CALCULATE(SUM('CLIENT DATASET'[Model Breach]),PARALLELPERIOD('CLIENT DATASET'[Time of Breach].[Date],-1,MONTH)) Any other way I can create something like this?
Getting the difference of a value between two seperate time slicers.
Hey Everyone, I'm trying to figure out a measure to give me what the difference between two time slicers are. We're trying to find out how many events has happened in the current date, the previous date and get a measure to determine what the movement between has been. I've seperated the Dates into two sheets form the samesource, one will be my "Comparison Month" and the other "Current Month" The formulas are as follows, and both of them give me the correct answer. Comparison Month= calculate([Count Total Instances],filter('Workforce','Workforce'[Start Date ]= max('Start Date Comparison'[Start Date ]))) Current Month = calculate([Count Total Instances],FILTER('Workforce','Workforce '[Start Date ]=max('Workforce'[Start Date (bins)]))) Problem occurs when I want to make the measure to subtract Current from the Comparison. I use the formua Movement = [Current Month] - {Comparison Month] However, for some reason it appears that the comparison is = 0, as this formula just returns to Current Month E.g. Current Month= 10 Comparison Month = 8 Movement=10 (when it should be 2) Thank you!
