Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
hi
i am trying to calculate the number of months between a certain date and the current date,
can u help me.
i only find solutions for 2 dates but i need the second date to be dynamic
thanks
Solved! Go to Solution.
Hi,
If you have a date column, for example [dateColumn], you can use the following DAX calculation:
new column = DATEDIFF([dateColumn], NOW(), MONTH)
Hi,
If you have a date column, for example [dateColumn], you can use the following DAX calculation:
new column = DATEDIFF([dateColumn], NOW(), MONTH)
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
97 | |
93 | |
87 | |
68 |
User | Count |
---|---|
173 | |
134 | |
132 | |
102 | |
95 |