Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have an urgent request as we are going live tomorrow with the report. I have the a dataset (example file link below) with existing columns from A to E. I have added extra columns from F to M using excel formulas. I need to add the same columns in the same datatable in PowerBI. Can you please help?
Column F - Concatenates the Previous Month & Year based on dates in Column A
Column G - Concatenates the Previous Month & Year based on dates in Column A
Column H - Cumilative sum of Column E for each month based on dates in Column A
Column I - Cumilative sum of Column D for each month based on dates in Column A
Column J - Cumilative sum of Column D for each prior month based on dates in column A
Column K - Number of days in the month for date in column A
Column L - Number of days in the month prior to the month of the date in column A
Column M - For each row, DBO = ((Column H)*Sum(Column K, Column L)) Divided by Sum of Column I & Column J.
Thank you in advance for your help.
Solved! Go to Solution.
Hi @HellRaizer2310 ,
I created an extra date column and used measures to show the result.
Here is my test file.
Hi @HellRaizer2310 ,
I created an extra date column and used measures to show the result.
Here is my test file.
Hi @HellRaizer2310 ,
I found two sheets in your file. Which one do you want?
At the same time, I found Sheet2 has only 4 columns( A,B,C,D ) and column C has a "#DIV/0" error. You could check if these data are correct.
The sheet in question is Sheet 1 with raw data and the calculated new columns. Sheet to will be the final output table that I need to create as a visual.
The Div#0 error is for the month of December 2017 in the previous month billing column. This is because the raw dataset doesn't have data before December 2017, so no previous month of November 2017.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
95 | |
83 | |
70 | |
66 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |