ContributionsMost RecentMost VotedSolutionsRe: Calculation with previous month's value smpa01 Do you have any recommendation for improving performance? When I run this with my real data, it is taking about 3 hours to run. Calculation with previous month's value I have excel calculation that I would like to replicate in Power Query. Is this possible in Power Query? SolvedRe: Calculation with previous month's value Thank you. Could you explain the code little bit? What if I change my original column name to "Current"? which part of the code would change? Also, would this be only way? I am little worried about the performance as my real data is little big Find the first date that hits the goal I am trying to find the first date that hits the goal (100 in this case) per ID Below is the sample data structure and desired output What would be the DAX Formula for calculating the "First Date to hit the goal"? SolvedCOUNTIFS in DAX Hello, I am trying to do calculation below: The logic is to count rows that have same color but later date What would be the dax formula for this? SolvedRe: DAX calculation with incremental value I am getting the same result Re: DAX calculation with incremental value I don't think the above code works... Am I missing something? DAX calculation with incremental value Hello, I am trying to calculate the "Forecast Value" based on the "Color" below. What would be the DAX formula for this? Solved
Data PrivacyMicrosoft Fabric Community and Privacy To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide. Read the guide
