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 folks,
Looking at a dataset where I'm trying to work out the duration of months open from the start date.
Example:
Start date | End date | Months Open |
05 December 2023 | 10 December 2023 | |
06 May 2022 | 01 April 2023 | |
07 November 2022 |
I was previously using
Solved! Go to Solution.
Hi,
try something like this:
Months Open = IF( ISBLANK('inYear'[End date]), DATEDIFF('inYear'[Start date], TODAY(), MONTH), DATEDIFF('inYear'[Start date], 'inYear'[End date], MONTH) )
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Hi,
try something like this:
Months Open = IF( ISBLANK('inYear'[End date]), DATEDIFF('inYear'[Start date], TODAY(), MONTH), DATEDIFF('inYear'[Start date], 'inYear'[End date], MONTH) )
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Thank you, that has worked wonderful!
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 |
---|---|
113 | |
89 | |
84 | |
76 | |
64 |
User | Count |
---|---|
148 | |
115 | |
110 | |
102 | |
95 |