Visualize table with date before a maximum date from a slicer
Hi everyone, I need to create a measure (or other method) to see rows details in my "details page" from my "overview page" not considering start date from slicer date on the "details page". DATA MODEL Table Ticket_PBI: ticket_id (type: string), input (integer), output (integer), input_date (date) Table Calendar_PBI: calendar_date (date) ...are all values from 01/01/2024 to 31/03/2024 Table relationship in the data model: Calendar_PBI (dim table) * -> 1 Ticket_PBI (fact table) REPORT PAGE 1 I have created a page named 'TICKETS OVERVIEW'. I have added the calendar_date (a slicer with a style between) with default values set from start date 01/02/2024 to end date 10/02/2024. I have also added a card that shows the sum of inputs without considering the start date of the slicer from point 1. The card contains a DAX measure "stock current" defined as follows: CALCULATE(SUM(Ticket_PBI[input]), FILTER(Ticket_PBI, Ticket_PBI[input_date] <= MAX(Calendar_PBI[calendar_date])), FILTER(Ticket_PBI, ISBLANK(Ticket_PBI[output]))) So, the result of my card will be = 3, as there are only 3 input_dates that are <= the MAX(Calendar_PBI[calendar_date]), which is 10/02/2024. REPORT PAGE 2 I also created a page named 'TICKETS DETAILS'. I have added the calendar_date (a slicer in style between) with default values set from start date 01/02/2024 to end date 10/02/2024. This slicer is synchronized with the slicer from point 1 of the 'TICKETS OVERVIEW' page. My goal is to display all the ticket_id that meet the "stock current" measure created in point 2. That is, all those ticket_id where their input_date is <= the MAX(Calendar_PBI[calendar_date]) of the slicer. an example of DESIRED OUTPUT, a table visual with these columns and rows:
Currency conversion with currency and year filters
I have 4 tables downloaded from the bank regarding exchange rates (CurrencyRates_2020,CurrencyRates_2021, etc.) in which there are columns with currencies, months and exchange rates, in the finance table there are columns amounts, inflows, outflows, date. I also added a table that contains currency column that I used to create the filter. What I would like to do is create a measure for amounts, outflows and inflows that will convert to the currency selected by the filter in the year selected by the filter. I've only written the part for the selected currency , but I don't know how to add a date filter. I would like it to fetch me data from the file "CurrencyRates_2021" when I select the date 2021 etc. I wanted to add at the beginning IF(AND(ISFILTERED('Currency'[Currency]),ISFILTERED('Consulting Finance'[Year]) [...] But I have no idea what to write next.How to extract names (Table1) from Id (Table2)
I have two tables one for student’s course information, another for Course Instructor Name. The two tables are joined by Course Instructor PIDM which is common key in both tables. In Expected table (3rd Table I have the Course Instructor PIDM. I want to add the course instructor name on this table too -How can I get this? Thanks in advance for your time and support.
DAX to return a column that has multiple filter criteria and multiple tables
Hi Good Day, I have a proper data set that involves three tables viz, 1)DataInvoice 2)Points 3)Factor I need a visual that shows Date column from Datainvoice,units column from datainvoice table multiplied with value column from Factor table. But the above can happen with few filter criteria as below 1)Date column from Datainvoice should fall between Start and End date of factor table and then return corresponding Value column 2)while filtering the above we should make sure that DBName-point-id from datainvoice should match DBName-point-id of points table which inturn looks for DBName-Utility in factor table and picks up the VALUE column This is how the relationship looks: I want the output to look like below in a visual File Portfolio performance Looking forware to your response Thanks in advance amitchandak Ashish_Mathur Greg FreemanZ Greg_DecklerIndexed numbered column
I do see similar posts to what I am looking for, but it seems like this would be simple DAX. I have a class registration system for internal training here in my organization and now I am creating a Power BI report to show those who are registered for a particular day and session. I would like the registrants to be numbered, in numeric order. (for those familiar, it would be a dim i as int; print i; i+=1). The underlying datatable does have an id column, but this would not work as it is just an identity spec. I have found some examples of DAX that use RANKX, but maybe I am using it wrong. I just need this numbered column (1, 2, 3, etc) for a filtered Class session. Thanks
