Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

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...
  • danextian's avatar
    danextian
    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.