Use slicer to dynamically select column
How can I use a slicer to dynamically select a column from my table? I want to have two slicers: the first to select the function and the second to select the column. I can get the first slicer working, but having issues with the second.
PowerBI. Uses slicer to dynamically select column
How can I use a slicer to dynamically select a column from my table? I want to have two slicers: the first to select the function and the second to select the column. I can get the first slicer working, but having issues with the second.
PowerBI DAX – Using the result of SELECTEDVALUE() in the FILTER() Function
I have the following code to create a new Table in PowerBI based on a condition:
DAX HELP: How do I create a measure that filters a table based on a slicer value using a MONTH SLICER
I have created a matrix table with Revenue. I want to be able to select a month from a slicer, and the the columns adjust to +30 day forecast & + 60 day forecast from whatever month was selected. For some reason the +60 days is populating the +30 day when I select any month. Here is the +60 formula: Budget 60 =
VAR SelectedMonth = SELECTEDVALUE(‘Calendar'[Month])
VAR StartDate =
IF(
ISBLANK(SelectedMonth),
TODAY(),
DATE(YEAR(TODAY()), MONTH(DATEVALUE(SelectedMonth & ” 1″)), 1)
)
VAR EndDate = StartDate + 59
RETURN
IF(
ISBLANK(StartDate) || ISBLANK(EndDate),
BLANK(),
CALCULATE(
SUM(budgetByAccountNumDaily[amount]),
FILTER(
budgetByAccountNumDaily,
budgetByAccountNumDaily[dateOf] >= StartDate &&
budgetByAccountNumDaily[dateOf] <= EndDate &&
RELATED(accounts[maincat]) = “revenue”
)
)
) Please advise!