Power BI DAX with DAX Stuido to Calculate SMA for Bollinger Bands


 

Comments

Post a Comment

Popular posts from this blog

Excel VBA Tips: A Macro to Generate Yearly Loan Schedule Report with Aggregated Monthly Re-Payments

Image
In this video, to provide users with a summarized yearly loan schedule report, I guide viewers in creating a new VBA macro based on modifying my previous Video demonstrated VBA macro for monthly loan schedule report which reveals interest and principal payments over the long term. The process involves two vertical VBA project windows and adjusting variables, calculations, and formatting. The updated procedure is offering an aggregated yearly report for different loan terms. Ths VBA codes is provided as following: Sub GenerateLoanReport_AggregatedYearlyPeriodReport() ' Created by MIKE GuangYuan YU on 8th of July , 2023 for M.Y BI & Analytics youtube channel     ' the procedure is to create loan report at yearly repayment period     ' Version 1.0          'I. Define required variables         Dim wsLoan, wsLoanReport As Worksheet         Dim LoanAmount As Double         Dim Interes...
Read more

Power BI Advanced Visualizations & R : Circular BarPlot with R Script Visual.

Image
  In the video I have shared a method to draw the circular barplot in power BI desktop file. As shown in the screen, the Circular BarPlot, which wraps a barplot that has larger numbers of categorical entities in circular shape, thus with it users can obtain all entities with their measure in a more eye catching organization space chart. To get this Circular Barplot chart in power BI we need to employ the power BI R script visual.  To Enable R scripts Visual feature in Power BI Desktop , we need go to File > Options and settings > Options > R Scripting. In the R scripts options you have two fields to fill. First one is to choose home directory for R, which means you need first to install a R engine and select the installed R engine location for the field. To install R engine we may click the  link ”how to install R”. it brings us to the Microsoft learning site regarding where to download R engine and how to install it.  The second field is to choose which R I...
Read more

Power BI Power Query & R: Calculate MACD Indicators With Assumed Initial Values

Image
  The video shares a method by running R script in power query to calculate MACD (Moving Average Convergence Divergence) Indicator with Assumed Initial Value which come from the first closing price data point. In video the advantages and disadvantages of the two MACD calculations, one with initials and one without initials, are compared in a table list. The calculation R scripts are well explained in details with each line in the video as well. You may find and copy the R code lines in my blog site which URL is attached in following. The R code lines as: # Step 1: Load dataset and format data  Dataset <- dataset # format date type as expected date format day/month/year Dataset$Date <- as.Date(Dataset$Date, format = "%d/%m/%Y") # Ensure close_price is numeric Dataset$Close <- as.numeric(Dataset$Close)   # Step 2: Creat Function to calculate EMA calculate_EMA <- function(x, n = 9) {   multiplier <- 2 / (n + 1)   ema <- numeric(length(x)) ...
Read more