Middle Ages - Wikipedia Step 1: Create a Slicer. Also, read: Power BI date hierarchy [With 21 real examples]. Step 1: Splitting your table into multiple smaller tables of the same size. Step 2: Adding the KPI Trends. SELECTEDMEASURE() is dynamic and takes a look at current measure in the pivot table. Can you please post a small screenshot showing the two columns being passed to the DIVIDE function, and the result. When creating a pivot table from that in excel it doesn't aggregate the calculation properly. Please select the Split Columns and then select By Delimiter option. How to Get Your Question Answered Quickly. Please log in again. Attend online or watch the recordings of this Power BI specific conference, which includes 130+ sessions, 130+ speakers, product managers, MVPs, and experts. You then rename the columns as follows: Your final table looks like the one in the following image. This assumes that everything is a column. Please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490The most important parts are:1. I need to calculate percentage and this is the DAX formula which isnt working: Divide function works if I put like this: But when I put column PLANNED_SALES instead of number two as a result I get empty column Why is that? Initially, we will load the data set using the get data option. In Split column by Number of Characters, apply the following configuration: Number of characters: 6. Datediff Power BiReturns the number of units (unit specified in You can now change the name of the columns and also define the data types of each column as follows: Your final table will look like the one in the following image.