Andrei Khaidarov, Microsoft MVP, PhDinMicrosoft Power BIDAX Power BI: Exploring Date Operation Logic Functions in Data AnalysisIn the realm of data analysis, understanding the functionalities of date operation logic functions is crucial. These functions can be…Mar 17Mar 17
Andrei Khaidarov, Microsoft MVP, PhDinMicrosoft Power BIDAX Power BI: Unveiling the Dynamics of Time — Date and Time Functions in DAXIn the world of data analysis, the dimension of time plays a pivotal role. Whether you’re forecasting, reporting, or analyzing, the way…Jan 28Jan 28
Andrei Khaidarov, Microsoft MVP, PhDinMicrosoft Power BIDAX Power BI: Calculation of growth and increase using expressions for previous/next days, months…A special case of the PARALLELPERIOD function:Jan 81Jan 81
Andrei Khaidarov, Microsoft MVP, PhDThe Hidden Pitfalls of Public Year-End Reviews: A Deep Dive into Self-Reflection and HonestyAs the year draws to a close, it’s common for individuals to engage in a ritual of reflection, often shared publicly on various platforms…Dec 29, 2023Dec 29, 2023
Andrei Khaidarov, Microsoft MVP, PhDinMicrosoft Power BIDAX Power BI: Time Frame of Analysis — Mastering DATEADD and SAMEPERIODLASTYEARLet’s consider two types of functions for working with dates. The first type is the SAMEPERIODLASTYEAR function. This function is a…Dec 18, 2023Dec 18, 2023
Andrei Khaidarov, Microsoft MVP, PhDinMicrosoft Power BIDAX Power BI: Difference in the use of DATEADD and PARALLELPERIODConsider the date functions DATEADD and PARALLEDPERIOD, which create a column of dates shifted relative to the original dates.Nov 14, 20231Nov 14, 20231
Andrei Khaidarov, Microsoft MVP, PhDinMicrosoft Power BIDAX Power BI: Creating a calendar with additional parametersSupplement your calendar, which consists of only one column, to see additional insights.Oct 20, 2023Oct 20, 2023
Andrei Khaidarov, Microsoft MVP, PhDinMicrosoft Power BIDAX Power BI: ENDOF & OPENING/CLOSING BALANCE — Calculating expressions based on a snapshot of…Sometimes, when solving analytical tasks, we need to sum some values not as a sum for some dates, but as a sum for a certain date, i.e. we…Oct 8, 2023Oct 8, 2023
Andrei Khaidarov, Microsoft MVP, PhDinMicrosoft Power BIDAX Power BI: CALCULATE — Calculation of the cumulative sales totalThis article will break down the calculation of the cumulative total by order number.Sep 20, 20233Sep 20, 20233
Andrei Khaidarov, Microsoft MVP, PhDinMicrosoft Power BIDAX Power BI: Calculating revenues by manager — FILTER or CALCULATE?Let’s consider in practice the basic differences between the FILTER and CALCULATE functions.Sep 3, 20232Sep 3, 20232
