DAX Help - how to calculate a monthly average from daily or hourly data
Автор: Access Analytic
Загружено: 2023-07-16
Просмотров: 9544
Описание:
DAX is a way of thinking, and here we need to summarize data using a Year Month field and then average the result.
Who ya gonna call for help?
00:00 Intro
00:21 The Data and Scenario
00:55 The DAX Formula (with Ctrl Shift L trick)
01:29 Using the Months Since Today column
02:15 Demonstrating what VALUES and the formula does
04:14 Alternative with SUMMARIZECOLUMNS
LINK TO POWER BI FILE
https://aasolutions.sharepoint.com/:f...
The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. https://accessanalytic.com.au/
Did you know I've written a book "Power BI for the Excel Analyst"?
https://pbi.guide/book/
Connect with me
https://wyn.bio.link/
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке:
![Calculating Average Monthly Purchases In Power BI Using DAX [2023 Update]](https://imager.clipsaver.ru/eNnSUdo4UNU/max.jpg)
![Как рассчитать средние значения за день в Power BI [обновление 2023 года]](https://imager.clipsaver.ru/IOlj7yGPGKs/max.jpg)
