Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!