Forum Discussion
Anonymous
1 year agoNot applicable
Date format in excel
Hello, I've created only one pbi dashboard so far, and i need to create a new one. I've a bit of issue regarding the dates. I have data for each month of 2025. For the previous power b...
- 1 year ago
Hi Anonymous
What do you mean by Sometimes it's not just the sum of the months? If your table has been transformed to a long and narrow format as suggested by rajendraongole1, and together with a separate date dimensions table, time intelligence calculations should be relatively simple. Please see the attached sample pbix.
v-ssriganesh
1 year agoCommunity Support
Hi Anonymous,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.