Create a custom static table using DAX
I am trying to design this chart in powerbi. The x axis contains different time limits. Currently this is design in excel and the table below is the source of data Average Tests March 2 April 1 - 28 4 April 29 - July 17 56 July 20 - Oct 9, 2020 63 Oct 12 2020-Nov 11, 2022 15 This table is created after getting average test from the same column on a different table below Date Number of Tests 03/09/20 1 03/10/20 2 03/11/20 1 03/12/20 0 Currently powerbi has access to the primary dataset below Date | Name| Race/Ethnicity | Result My inital thought was using DAX ROW or DATATABLE to create a Virtual or static table and use the average function to get the numbers. I am stuck!!! I will honestly appreciate any help provided.Sum data from 2 unrelated tables (key dates)
I have 2 tables, both have values separated by dates, I need to add these values by the dates shown. They do not have relationships in common, but are related to the dCalendar table. I tried to create a new table and use LOOKUPVALUE to generate the 2 values in a table and add them up ,but it still gives an error when the key provided has the date value I would like to know how can I add both values and separate them by dates The value highlighted in red would be the value that I must add, the value in blue would be the relations with the dCalendar tableCopy value from one row to underlying rows
Hi all ! I have searched for a solution to this problem without luck - hopefully this issue is known to others: I have a table with date and transactions. The problem is that the date is not repeated on the rows - see example below. I am looking for the soluttion to copy the date and replace the "null" with date - until a new date is reached: My table: This should read: Thankful for any hint and suggestions ! Rgds Eirik B
Updating table without losing previous rows
Hello everyone, I have sort of a problem, we have an access to goverment table showing EURIBOR interst rates, the downside of this table is that it only contains 10 rows, and after each refresh it keeps the 10 rows removing previous dates and adding new ones. So I was wondering is there any type of option inside PBI to update the table with new values by adding new rows and keeping older information?? And for our report we would need larger historical data and for that we would need this table to be updated with these new values by adding new rows instead of overwrighting the old values and keeping it in form of 10 rows only. I don't have much expirience with PBI we are primarly working with Tableau but we added PBI into our group and we want to use it properly, so if I need to clarify something just say what you need me to explain. Thanks in advance for any help!!!
Getting values and filtering a virtual table
Hi all, I need to create a table inside the measure (not as another table) and get values from there. If I run as below, it works fine I see the table is Ok How to write an expression that works for specific columns? For example: MAX(_index[Value2) ... that will return 3.1 ... or FILTER(_index,[Value1] = 2 ... to select that specifc row
