Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Dear all
I am not sure how to address this problem. I have a bunch of loans where the majority of them have semi annually or quarterly installments.
I need to create a monthly view on all loans, which leads me to the issue on how to solve this. Should do it in the Query where each loan have a issuing date and maturity date. Or would it be better to do it in DAX and somehow create a virtual calendar to fill the gaps?
Br Espen
Solved! Go to Solution.
Hi @jaco1951,
I'd like to suggest you to expand date range to detail date, then you can use detail date to create an calendar table and build relationship.
Convert date ranges into list of dates?
After these operation, you can use calendar direct operation each date between date range.
Regards,
Xiaoxin Sheng
Hi @jaco1951,
I'd like to suggest you to expand date range to detail date, then you can use detail date to create an calendar table and build relationship.
Convert date ranges into list of dates?
After these operation, you can use calendar direct operation each date between date range.
Regards,
Xiaoxin Sheng
Excellent function, I was not aware that one could do this.
Thanks.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
88 | |
69 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |