Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

filling missing dates in dataset

Hi All, i have a difficult scenario here, kindly provide your ideas if this can be possible to achieve.   say we have data for the month of january, we record data only on business days. when eve...
DAX Measures
Need Help
Need Help DAX
Need Help DAX measure
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
5 years ago

Hi,

You mentioned that there will not be any row if there is no business on a certain day.  If that statement is correct then why do you have rows with 0 value in the sample data?  Please clarify.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Ashish_Mathur  i just provided the sample data with 0 on when there is no business. but actually i have last 2 rows in my dataset. thnaks for your time in looking this.

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

      Hi,

      There are 21 working days in January 2021.  The average margin per working days is 419.05.  You may download my PBI file from here.

      Hope this helps.