{"type":"doc","content":[{"type":"layoutSection","content":[{"type":"layoutColumn","attrs":{"width":66.66},"content":[{"type":"paragraph","content":[{"text":"Вычисляет разницу между двумя датами в заданных единицах времени, таких как дни, недели, месяцы или годы.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Синтаксис","type":"text"}]},{"type":"blockquote","content":[{"type":"paragraph","content":[{"text":"DATEDIFF(<дата 1>, <дата 2>, <интервал>)","type":"text","marks":[{"type":"code"}]}]}]},{"type":"paragraph","content":[{"text":"где:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"<дата 1>","type":"text","marks":[{"type":"code"}]},{"text":" и ","type":"text"},{"text":"<дата 2>","type":"text","marks":[{"type":"code"}]},{"text":" – даты, разницу между которыми нужно вычислить.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"<интервал>","type":"text","marks":[{"type":"code"}]},{"text":" – единица измерения, в которой будет возвращена разница. Возможные значения:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"SECOND","type":"text","marks":[{"type":"code"}]},{"text":";","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"MINUTE","type":"text","marks":[{"type":"code"}]},{"text":";","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"HOUR","type":"text","marks":[{"type":"code"}]},{"text":";","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"DAY","type":"text","marks":[{"type":"code"}]},{"text":";","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"WEEK","type":"text","marks":[{"type":"code"}]},{"text":";","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"MONTH","type":"text","marks":[{"type":"code"}]},{"text":";","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"QUARTER","type":"text","marks":[{"type":"code"}]},{"text":";","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"YEAR","type":"text","marks":[{"type":"code"}]},{"text":".","type":"text"}]}]}]}]}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"Положительный результат возвращается, если ","type":"text"},{"text":"<дата 2>","type":"text","marks":[{"type":"code"}]},{"text":" больше ","type":"text"},{"text":"<дата 1>","type":"text","marks":[{"type":"code"}]},{"text":". Отрицательный результат возвращается, если ","type":"text"},{"text":"<дата 1>","type":"text","marks":[{"type":"code"}]},{"text":" больше ","type":"text"},{"text":"<дата 2>","type":"text","marks":[{"type":"code"}]},{"text":".","type":"text"}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Пример использования","type":"text"}]},{"type":"paragraph","content":[{"text":"Предположим, у нас есть таблица ","type":"text"},{"text":"Date","type":"text","marks":[{"type":"strong"}]},{"text":", в ней два столбца с датами (","type":"text"},{"text":"Date ","type":"text","marks":[{"type":"strong"}]},{"text":"и ","type":"text"},{"text":"End Date)","type":"text","marks":[{"type":"strong"}]},{"text":", и мы хотим посчитать количество дней между двумя датами, чтобы, например, узнать, сколько времени займет промоакция. Для этого мы воспользуемся следующей формулой:","type":"text"}]},{"type":"codeBlock","content":[{"text":"Продолжительность промоакции =\nSUMX ( Date, DATEDIFF ( 'Date'[Date], 'Date'[End Date], DAY ) )","type":"text"}]},{"type":"panel","attrs":{"panelType":"warning"},"content":[{"type":"paragraph","content":[{"text":"Обратите внимание, что в примере используется функция агрегации ","type":"text"},{"text":"SUMX","type":"text","marks":[{"type":"code"}]},{"text":".","type":"text"}]}]},{"type":"paragraph","content":[{"text":"В данном примере вычисляется количество дней между двумя датами, где ","type":"text"},{"text":"'Date'[Date]","type":"text","marks":[{"type":"code"}]},{"text":" и ","type":"text"},{"text":"'Date'[End Date]","type":"text","marks":[{"type":"code"}]},{"text":" являются столбцами в таблице ","type":"text"},{"text":"'Date'","type":"text","marks":[{"type":"code"}]},{"text":", содержащими начальную и конечную даты соответственно. Результатом будет целое число, представляющее количество дней между двумя этими датами.","type":"text"}]},{"type":"rule"},{"type":"paragraph","content":[{"text":"Смотрите также","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"type":"emoji","attrs":{"id":"1f4c4","text":"📄","shortName":":page_facing_up:"}},{"text":" ","type":"text"},{"text":"Моделирование данных с помощью DAX","type":"text","marks":[{"type":"link","attrs":{"href":"https://visiology-doc.atlassian.net/wiki/spaces/3v8/pages/450628876"}}]},{"type":"hardBreak"},{"type":"emoji","attrs":{"id":"1f4c4","text":"📄","shortName":":page_facing_up:"}},{"text":" ","type":"text"},{"text":"Поддерживаемые функции DAX","type":"text","marks":[{"type":"link","attrs":{"href":"https://visiology-doc.atlassian.net/wiki/spaces/3v8/pages/450628930"}}]},{"type":"hardBreak"},{"type":"emoji","attrs":{"id":"1f4c4","text":"📄","shortName":":page_facing_up:"}},{"text":" ","type":"text"},{"text":"Математические операторы","type":"text","marks":[{"type":"link","attrs":{"href":"https://visiology-doc.atlassian.net/wiki/spaces/3v8/pages/450629734"}}]},{"type":"hardBreak"},{"type":"emoji","attrs":{"id":"1f4c4","text":"📄","shortName":":page_facing_up:"}},{"text":" ","type":"text"},{"text":"Примеры","type":"text","marks":[{"type":"link","attrs":{"href":"https://visiology-doc.atlassian.net/wiki/spaces/3v8/pages/450629765"}}]}]}]},{"type":"layoutColumn","attrs":{"width":33.33},"content":[{"type":"paragraph","content":[{"text":"Нужна дополнительная помощь?","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Свяжитесь с технической поддержкой","type":"text","marks":[{"type":"link","attrs":{"href":"https://ru.visiology.su/products/support-contacts"}}]},{"text":".","type":"text"}]}]}]},{"type":"paragraph"}],"version":1}

Браузер не поддерживается