财务分析的小伙伴们在日常工作汇报中时常会遇到领导对于不同维度的业务数据在同比或者环比上面的分析需求...
This is what I need, very simple calculation to do in excel, but I don't know how to recreate it in power bi... I could do it manually for each year, but if my next data set have 20 years it's going to be a nightmare... I was trying to get a generic formula to calculate...
I have tried the formula, and again it doesn't work 😞 Please see a screen shot below: I have put the formula in a Card to try it. There's no red underline so I guess the formula is OK? However there's an error message in the Card after adding the measure: How could I make...
I must mention that I was able to do this by inserting a column in the Power BI table view. However, as my project is on a server, I cant edit the table and can just create a new measure. However I am struggling with the DAX formula for the same. Please help: Customer...
I used Allan's formula for calculating Last Year Sales value. Message 4 of 4 1,808 Views 0 Reply Greg_Deckler Super User 03-11-2020 07:30 AM Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get...
i want to calculate the year on year change in Tuition Fee based on the Account i tried to create a date table but it didnt work Currently trying with this DAX Formula YoY Growth = VAR CurrentYearFee = SUM(Sheet1[Tuition ]) VAR PreviousYearFee = CALCULATE( SUM(Sheet1[Tuition ]),...
i want to calculate the year on year change in Tuition Fee based on the Account i tried to create a date table but it didnt work Currently trying with this DAX Formula YoY Growth = VAR CurrentYearFee = SUM(Sheet1[Tuition ]) VAR PreviousYearFee = CALCULATE( SUM(Sheet1[Tuition ]),...
So I'm back to this setup, and I have been able to use the TODAY function to get this year's data and last year's data using a DAX formula. However, I'd really like to just have all the sales data flow in and then use a slicer to toggle between: Today Last Week Month-To-Da...
i want to calculate the year on year change in Tuition Fee based on the Account i tried to create a date table but it didnt work Currently trying with this DAX Formula YoY Growth = VAR CurrentYearFee = SUM(Sheet1[Tuition ]) VAR PreviousYearFee = CALCULATE( SUM(Sheet1[Tuition ]),...
I have a monthly home sales data and have managed to computed the %YoY change by creating another measure (Prev_Total Home Sales) using the following DAX Formula: Prev_Total Home sales = CALCULATE([Total home sales _measure],DATEADD(Housing[Date],-1,year)). However, I am not able ...