Hello i have just one database and need to create a graphic using values with accounts paid off and open accounts, but to identify then i need that on a column (open or paid of) choose open, in anoth...
Hi , I have some roles in ‘Table A’ with ID’s. Now each ID must have all the roles assigned but some Id’s are not assigned with certain roles, which means there are some missing roles for each ...
Hi I've got multiple measures that are counting operations from the REST API based on dates. - Operations total - Operations in last 30 days - Operations in last 90 days etc &nbs...
Hello, I have a Power BI dashboard and I am trying to determine what is the % change from one week to the next. I have a Date Table and have created a relationship between the Date Table and...
Dear all, I'm currenty working on issue to get only first value on Marix within Month, I used Firstnonblankvalue but I get the result without month, as you can see below I want to get only t...
Hi guys, I've a table like this This table is linked to calendar table. In report I use a filter to set a time period, for example: from 19/03/2024 to 30/04/2024. I need to create a m...
Hi I'm trying to relate 2 tables but I'm not succeeding so I would like the help of the community. I need to bring the invoice number information from table 1 to geographic positioning table 2. ...
I'm trying to find the way to do bottom N + Others by using the below command as simple as I could; BottomNProducts = VAR TopGPTable = TOPN(8 , ALLSELECTED(ProductWit...
Hello, I have some problems with the sum of a measure column. This is my table: As you can see here, Total of the Overview column is not added up correctly. I calculate my Actuals column as fo...
Hi All, I have a column of values (production forecast) and a date table with the column, Week Begining applied to the filters Pane. I've filtered out any zero values and have Average Foreca...