Convert date in date type, not string
Hi guys, i try to use report builder but i have some problems with data type. I've this query When i try to filter date (for example date >= 01/01/2024), I can't to do this because it convert data in string. In power bi the field is date type, not string. How can I convert the column in date type? Thank you all 🙂
Evolution rate only for common months
Hello guys, I'm trying to display an evolution rate which compares datas over 2 years. BUT, I only want common months to be part of the calculation. (In 2022, I have datas for 6 months, and in 20221 I have datas for 5 months). I just want my measure to calculate the rate between the 5 common months. Here is an extract of my data. And here is my DAX measure : Rate N /N-1 = divide ( sum('file'[Data N])-sum('file'[Data N-1]),sum('file'[Data N-1]),"NA") Of course, I want to be able do display my charts for each year, using a slicer for years. Can someone give me the solution please ? I'm sure it's not that difficult ! Thans a lot !
