DAX Help - how to calculate a monthly average from daily or hourly data
Автор: Access Analytic
Загружено: 2023-07-16
Просмотров: 9386
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/
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
![Как рассчитать средние значения за день в Power BI [обновление 2023 года]](https://ricktube.ru/thumbnail/IOlj7yGPGKs/mqdefault.jpg)
