Issue with Multiple date keys and displaying dates on report.
Hello, i am working on a SSAS Tabular model to support Power BI report development. Our main fact table has multiple dates (Order Date, Paid Date, Shipped Date) with the Order Date being the active relationship to the date dimension. One of our reports requires a table that has the following columns (amoung others) Date and Amount by Paid Date. I understand how to build the measure "Amount by Paid Date" using USERELATIONSHIP to active the relationship between my fact.paid_date_key and the dim.date_key. Other than fully duplicating my date dimension to have a "Paid Date Dimension" and use that inactive relationship. how can i include "Paid Date" in my report table?Filter a Line Chart via DAX Measure to report ONLY for Max Date
Hi all, I have a requirement from our userbase that they'd like to be able to switch between measures reported in a line chart. The trouble I'm running into is that some of these measures can only be reported as of the max date - metrics such as Open Roles, % of Employees on a Succession Plan, etc. Using the 'Open Roles' measure as an example, when a user selects the option on the left for 'Open Roles', I'd like the Line Chart to ONLY report the value for the maximum selected date and exclude the other Month/Year values from the axis: I've tried MAX/MAXX/etc but am coming up short. Any ideas?MIN value of a slicer based on a date in MM.YYYY format
Good afternoon, Please help with advice. There is a field in the DATE format, contains only the month and year (2.2021, 8.2023, etc.). The client want to use a slicer in the "between" style (they don't like the extra Timeline slicer). Power BI automatically displays dates in the format dd.mm.yyyy, which means that the table value of 8.2023 corresponds to the value of 1.8.2023. I use the MIN and MAX functions to determine the minimum and maximum value of the slicer. I need that if I select a date other than the first day of the month, the selected month will be returned to me, not the next one. For example, for 5.12.2021, I need to get the value 1.12.2021 instead of 1.1.2022. Is it possible? Thank you in advance.First creation date per customer
Hi All, I have one simple table with two columns: - one column for the customergroup name -one column showing when that customer group was created A customer group can have multiple customers. That's the reason why we have multiple creation dates per customer group. I would like to create a dax that shows the first date of creation per customer group. Example: CustomerGroup1 has 3 dates but the first one was created the 1/01/2021 and therefore, I want to see that date shown up in a new column. Thanks very much for your help!
