Forum Discussion

paris's avatar
paris
Icon for Helper V rankHelper V
7 years ago
Solved

Convert monthly data to daily

Hi All,

 

I like to convert monthly data to daily data without using relationship. (Too many relationsghip already and got errors when I try to set up new relationship)

 

Is there anyway I can do by using dax or query?

 

 

All the best,

LoveParis

 

Need Help
  • v-eachen-msft's avatar
    v-eachen-msft
    7 years ago

    Hi paris ,

     

    The test is a table which is the same as your sales table. I just tested it in my environment, please follow your own table name.

     

    Best Regards,

    Eads

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

4 Replies

  • v-eachen-msft's avatar
    v-eachen-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi paris ,

     

    You can use CROSSJOIN() function to create a new table to combine your sales table and calendar table.

     

    TableCross =
CROSSJOIN ( test, 'calendar' )

    Then you can create a new table to display final result.

    FinalTable =
CALCULATETABLE (
    TableCross,
    FILTER ( 'TableCross', TableCross[Monthly] = TableCross[Column] )
)

     

    Best Regards,

    Eads

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • paris's avatar
      paris
      Icon for Helper V rankHelper V
      7 years ago

      Hi Eads,

       

      Thank you for your message!

       

      I tried first function [ TableCross=CROSSJOIN(test,'Calendar') ] but it came back with error " Failed to resolve name 'test', it is not a valid table, variable or function name. " Can I ask what does test mean? 

       

      I am wondering would it be possible to attach your file? 

       

      All the best,

      LoveParis

      • v-eachen-msft's avatar
        v-eachen-msft
        Icon for Community Support rankCommunity Support
        7 years ago

        Hi paris ,

         

        The test is a table which is the same as your sales table. I just tested it in my environment, please follow your own table name.

         

        Best Regards,

        Eads

         

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.