Hello guys, I'm havig trouble while trying to create a measure that compare two dates from to fact tables that are not (obviously) connected. I will explain my schema. First i have ...
Hi everyone, I have some monthly portfolio performance data on hand, along with the starting month for each portfolio. Additionally, I have historical monthly performance data for 3...
Dear DAX community, I would like to have a visual that has conditional hiearchy in one of the x axes. The example I give is a line graph, showing sales for 4 calendar years of data, wi...
How can I format the final grand total value like the rest of the row (dark blue, white text)? Is PBI Matrix missing this ability? It seems like it should be a basic function. Data filte...
Hi I'm trying to calculate a Percentile of a column with below syntax NetP95CyT = (PERCENTILE.inc(Outflow_PBI_Table[GROSS CyT FINALE], 0.95)) The formula is ok but I receiving the below e...
I'm trying to create a New table from an existing table, and filter the results for the new table by "RateType" and "EffectiveDate". In the new table, I need to bring over the row with the Max ...
I'm working with a dataset in Power BI that includes a table called 'ECN_AFFECTED_ITEMS_V'. This table has columns such as 'Part Number' and 'Release Date'. Each row represents an incident related to...
Hello, I have a Matrix that I have a filter built to show only items (Used NDC) that meet a dynamic condition. For each item, a formula (Accumulation Selection M) returns a 1 if true and BLANK() i...
I have a need for a date slicer to contain multiple options for date ranges as well as the option to choose a custom date range. I'd like the user to be able to choose from the options below.&n...
Hi I have a line chart that is repeating my 'Year' alongside my 'Month', I want to replicate how I show years on the column chart below; I have tried changing the drill down options and diff...