<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Measure with Time data doesn't work in DAX Commands and Tips</title>
    <link>https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Measure-with-Time-data-doesn-t-work/m-p/377778#M156516</link>
    <description>&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I have a table with a column [trip duration] defined with the format Time.&lt;/P&gt;&lt;P&gt;&lt;img /&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;When I use this column in a measure SUM, no problem.&lt;/P&gt;&lt;P&gt;But&amp;nbsp;when I create an AVERAGE on the same column, it's impossible for me to select the format Time and Date&amp;nbsp;:smileyfrustrated:&lt;/P&gt;&lt;P&gt;&lt;img /&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Any idea why ? And how to solve this problem ?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks&lt;/P&gt;</description>
    <pubDate>Fri, 16 Mar 2018 12:58:58 GMT</pubDate>
    <dc:creator>FredLEGUEN</dc:creator>
    <dc:date>2018-03-16T12:58:58Z</dc:date>
    <item>
      <title>Measure with Time data doesn't work</title>
      <link>https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Measure-with-Time-data-doesn-t-work/m-p/377778#M156516</link>
      <description>&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I have a table with a column [trip duration] defined with the format Time.&lt;/P&gt;&lt;P&gt;&lt;img /&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;When I use this column in a measure SUM, no problem.&lt;/P&gt;&lt;P&gt;But&amp;nbsp;when I create an AVERAGE on the same column, it's impossible for me to select the format Time and Date&amp;nbsp;:smileyfrustrated:&lt;/P&gt;&lt;P&gt;&lt;img /&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Any idea why ? And how to solve this problem ?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks&lt;/P&gt;</description>
      <pubDate>Fri, 16 Mar 2018 12:58:58 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Measure-with-Time-data-doesn-t-work/m-p/377778#M156516</guid>
      <dc:creator>FredLEGUEN</dc:creator>
      <dc:date>2018-03-16T12:58:58Z</dc:date>
    </item>
  </channel>
</rss>

