Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a table with one column containing repeating values or "Source" and another column containing just the “Date” for each record. I am trying to display the first/last date for each “Source”, but when I use the following formula I get a date in the middle of the range. I am newer to PBI so any help would be greatly appreciated! Below is a sample of the data I am talking about.
Date - End = DATEVALUE(Calculate(Max('Data Source'[Date])))
Date - End = max('1 Date Source'[Date])
Source | Date | Type |
Month 1 | 1/12/2020 | AOH |
Month 1 | 1/13/2020 | AGN |
Month 1 | 1/14/2020 | QXP |
Month 1 | 1/15/2020 | AOH |
Month 1 | 1/16/2020 | QXP |
Month 3 | 3/23/2020 | AGN |
Month 3 | 3/24/2020 | QXP |
Month 3 | 3/25/2020 | QXP |
Month 3 | 3/26/2020 | AOH |
same for Date - Start, just using Min
How would I say that Month 1 was from 1/12/2020 – 1/16/2020 and month 3 was 3/23/2020 – 3/26/2020? I tried using a table visualization and adding the Values of “Source”, the measure I made “Date – Start” and “Date – End”, but I am getting Month 1 1/15 – 1/15 and month 3 as 3/24 – 3/24.
Solved! Go to Solution.
@DreDre - Perhaps I am not understanding what you are going for here. See attached PBIX, is that what you want?
@DreDre - You should just need to do MIN and MAX assuming that your column is really a date column and not text for example.
@Greg_Deckler - When using the Min/Max, it ends up pulling a date in the table that matches the "Source" but is the same date for the Start/End which is where I am hitting the wall. The column is filtered as a date which I thought would be the fix, but I am still stumped.
@DreDre - Perhaps I am not understanding what you are going for here. See attached PBIX, is that what you want?
@Greg_Deckler I went to create a sample of what I was trying to explain and your right it looks like the min/max do work exactly as they should have so there is a problem with my underlying data that I need to root out. I appreciate your quick response!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |