Datetime operation

Question

Hi Power BI Gurus!,&nbsp;Please your help with this issue. I have a table with this detail:&nbsp;I have to use the "Date Start" column like a filter slicer to select the range of events where I need to review. The problem is with the time column, because when I'm selecting the the period of a complete month the duration show times from the next month. I need to calculate just the range selected with the filter slicer based on "Data Start".&nbsp;If I'm going to select the range beetween two months I need to se the complete detail for time in both times.&nbsp;Regards,&nbsp;&nbsp;

v-chuncz-msft · Accepted Answer

erickparra&nbsp;,
&nbsp;
You may check if the following post helps.
https://community.powerbi.com/t5/Desktop/Use-a-date-slicer-to-filter-on-a-period-instead-of-a-single-date/m-p/588265#M278953

Forum Discussion

Datetime operation

1 Reply

Related content

Converting Epoch Datetime into regular datetime format

Convert DateTime to Date

SQL Operator with multiple destinations

Expression Error We cannot apply operator < to types DateTime and Date

Use Wildcard Operator