Forum Discussion
Multiple Date Fields
Thank you JasonTX ! I did figure out a way to get it by searching through another thread. Highlighting both date columns in the query editor, then unpivoting those columns did the trick. Then I have a single date column from my main table connected to my date table, and an additional column that allowed me to toggle between Close Date and Created Date. This is allowed me to write the following measures:
And this ended up giving me what I was looking for. I appreciate all your help! You as well v-yuta-msft !
If you just want a measure count, this can help:
https://stackoverflow.com/questions/55873643/filter-data-between-start-date-and-end-date-in-power-bi
However, if you would like to create a table as mentioned, you will have to create a new columns and several measures mentioned below:
Column:
Namesfilter = Calculate(VALUES([Name]))
Measures:
CreatedDateFiltered =
var a = FILTER(Table1, Table1[CreatedDate] = MIN('Date Table'[Date]) && Table1[CloseDate] = MAX('Date Table'[Date]))
return MINX(a, Table1[CreatedDate])
ClosedDateFiltered =
var a = FILTER(Table1, Table1[CreatedDate] = MIN('Date Table'[Date]) && Table1[CloseDate] = MAX('Date Table'[Date]))
return MAXX(a, Table1[CloseDate])
CountFilter = COUNTROWS(FactInternetSales)
Make sure CreatedDateFiltered and ClosedDateFiltered are filtered to 'is not blank'.
Try this and see if it is closer to what you are looking for.
Thank you JasonTX ! I did figure out a way to get it by searching through another thread. Highlighting both date columns in the query editor, then unpivoting those columns did the trick. Then I have a single date column from my main table connected to my date table, and an additional column that allowed me to toggle between Close Date and Created Date. This is allowed me to write the following measures:
And this ended up giving me what I was looking for. I appreciate all your help! You as well v-yuta-msft !