Different column output basing on Parameter Selection
Hi Guys and Welcome Everyone! my first post in this community :). I have following query. I have created parameter using "New Parameter" -> "Numeric Range" Then I have edited parameter settings as follows: Then I would like to have column with different output depending on parameter selection. I wrote formula as follows: When I test it in report view, I always get "NOTPASSED", whatever I choose in the slicer. Do I miss anything or is there other workaround to achieve my goal?
Tabular Editor - Field Parameters - fields from more than 1 table
Hi Is it only possible to add fields from one table to create parametrs via Tabular Editor? In Analysis Services connected to a date warehouse I have various dimesnions which I would like to be selectable (customer, state, channel, salesperson etc). I have tried using the C# script posted by Daniel Otykier however seems it is limited to selecing fields from 1 table only. Is this correct?
Use Parameter to Slice Aggregate Measure?
Hello all - Based off the below dataset, I have summed the 'daysonjob' column on my dashboard. Is there a way to filter or slice that aggregation based off a parameter within DAX? For example - If a parameter is selected as "all", I would like to see the sum of the entire column 'daysonjob'. If the parameter is selected as 'remove days off site,' I would like to see the sum of 'daysonjob' where 'laboronsite' = 'Y'. Essentially, I want the user to be able to select 'Days On Job' as all days the job has been active or only days where labor was actually on site. Is this possible? From my memory, this can be easily achieved in Tableau, but I can't seem to figure out how to write a DAX measure with parameters. Thanks in advance,Can I have a slider in the report view change data in the Table view
Hello, I am working on a visual report for my Power Bi project, where I have a table matrix with numerous columns in it. I want to make sliders that works a weigh metric that changes the values in these columns. These columns are made up of the following. Column A, Standardized Column A Column B Standardized Column B Column C Standardized Column C Relative Column ABC Ranking of Relative Columns ABC My goal is to have a slider that adds a calculated weight to columns A,B,C and by changing the weight on this slider, this causes a trickle down effect where it changes the Standardized Column A,B, and C, Relative Columns ABC, and the Ranking of the Relative Columns ABC. The goal is to have these values change on the table the matrix, which serves as a filter for all other visuals on the panel. I have been able to create a parameter that works for changing the values in column on the table matrix, however I am unable to get this to have the trickle down effect. Has anyone ever created a slider that works like this?Dynamic date based revenue calculation
Hi, I have the following case: I am building a report based on an Excel file hosted on a SharePoint Online environment. The file basically contains CRM opportunity lines with creation date, modified date and expected revenue as relevant columns. I have also created a relatively standard calendar/date table. Since the Excel file is constantly being fed with new data I am looking for a way to dynamically calculate total expected revenues within a given timeframe (preferably determined by a date slicer). The selected date (or period like Q1 2022), would determine old_revenue as the sum of expected revenue in the period prior to the period selected and new_revenue as the sum of expected revenue in the selected time period. So far my research has led me to Dynamic M Query Parameters which looks like it could have been a viable solution, but since my data source is Excel based, I don't have the option to use DirectQuery. Another option I have succesfully tried is hard coding measures that calculate old_revenue as getting the first day of today's month and then summing the revenue of the month prior to that date but this would mean I would have to hard code all possible options (week, month, quarter and year).DAX formula to calculate rolling X average based on parameter & values from other columns
Hi all, I am trying to create a Column using DAX that calculates a rolling 8-week average based on a parameter/measure with multiple filters depending on the values of other columns. Data Structure: There is also a parameter for the current week number in cell K2: The column Forecast is what I am trying to create using DAX. What it does is: - If the week number is less than or equal to the Current Week, just copy the value under "Actual" (Column E) - Else, get the average of "Actual" (Column E) of the 8 weeks prior to the current week (if Current Week = 38, get average of weeks 30-37), subject to having the same FY, same KPI, and same Owner with the current row. In Excel, the correct formula for Row #2 would be: =IF( B2<=$K$2, E2, AVERAGEIFS( E:E, B:B,"<"&$K$2, B:B,">="&$K$2-8, D:D,D2, C:C,C2, A:A,A2 ) ) I am really struggling to find the right DAX syntax because I can't seem to figure out how to pass one of the values of the current row into the DAX filters. I tried doing something like this (without the IF statement) but obviously it's not working: I have uploaded the sample Excel and PBIX files for easier reference. You can see how the correct calculation is done in Excel. - XLSX: https://docs.google.com/spreadsheets/d/1fYG1dRtkthvLhxMTDXxbx1x_VmoVxf0Y/edit?usp=sharing&ouid=111734964497020988818&rtpof=true&sd=true - PBIX: https://drive.google.com/file/d/1TqT_xKZg3s7sSyZJr4yrQPtt-iW4mU8I/view?usp=sharing Any help will be greatly appreciated! Cheers, Andrew
What If Parameter Single Value Issue
Hi, I have the following generated series function to create a single value sliding slice: GENERATESERIES(0, 1, 0.0001) The slicer is formated to fixed decimal percentage. The slider works when you are moving it up and down and increments by the correct .0001 amount. The problem occurs when I try and type in a value. If I type in somthing like .3305 (to get 33.05%) the value skips to .3307 (33.07%). Please help, this has been extremely fraustrating to deal with.
