Unlike DAX, In Power Query, the Difference between 2 dates can be calculated by simply subtracting 2 date columns. But the problem is that the resulting column is in the Duration data type. Duration data is rarely helpful in any visualization so we have to convert duration data to units like Hours Minutes & seconds
Month: April 2023
In this blog post, Let’s discuss how to use Power BI DAX to compare the current day’s data with the previous day’s data in the current context. We’ll do it by using the stock price of 5 top US companies and then move on to, Compare the current month data with the previous month data