Forum Discussion

RobinIrving's avatar
RobinIrving
Frequent Visitor
1 year ago

Tables - incomplete months - calculation issues

Hello,    Ive done lots of searching and used copilot a lot but still cant quite get there. Apologies for the long post but its not easy to explain.    I am pulling in a table of forecast hours f...
Need Help
RobinIrving's avatar
RobinIrving
Frequent Visitor
1 year ago

Thanks for mentioning the dummy option - I managed to get that working well with a bit of fiddling. With this level of data it works fine.If I ever need anything more I will worl out a way to be able to provide a cleansed PBIX for you all to look at. Cheers

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi RobinIrving,

In fact, You only need to remove the sensitive data from the table records or tried to replace them to dummy values.(e.g. abc, test123)
Regards,

Xiaoxin Sheng

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi RobinIrving,

    Any update on this? 

    Regards,

    Xiaoxin Sheng

    • RobinIrving's avatar
      RobinIrving
      Frequent Visitor
      1 year ago

      Hello, 

       

      Yes I decided to go with the dummy rows for each month as a solution. Still got a few issues with this as some of the resources have multiple rows for themselves and also there are quite a lot of them with issues swith the way they have been set up as well. Rather comlicated but geting there. 

       

      Happy to class the creating duplicate month rows as a solution. 

       

      Cheers