Forum Discussion

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

Daily and non daily data

Hi,   I need to make a comparison on 2 tables, one contains of daily data and another one containes non-daily data. These are the tables: 1. Location Guarantee Table Location Version Status...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

     

RMV's avatar
RMV
Icon for Helper V rankHelper V
7 years ago

Hi Zoe,

 

Yes, that's right. It is a sum of production for each Location each month from the Daily Table.

Location A has total production = 105 in January 2019 (2019-01), and 88 in December 2018 (2018-12).

While Location B has total production = 82 in January 2019 (2019-01).

 

Daily Table only shows the illustration of the data structure, and not intended to show all data (to make it short) :smileyhappy:

So, if Location B apparently has production in December 2018 and/or moving forward, the result is expected to have the sum of production in each respective month for Location B. This is to be applied for Location A as well.

 

Regards,

 

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
7 years ago

Hi,

You may download my PBI file from here.

Hope this helps.

 

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

    Hi Ashish_Mathur,

    If I understand correctly from your file, Table Location Guarantee is expanded to each day by adding a Custom Column in Query Editor. Just wondering, is there an alternative to use DAX formula for this same purpose?

     

    Thanks,

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      7 years ago

      Not that i am aware of.

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

        Ashish_Mathur , thanks for the help.