Forum Discussion

sandeep_sharma's avatar
sandeep_sharma
Icon for Helper II rankHelper II
1 year ago
Solved

DAX basis different date columns

Hi,   I have 4 columns...as mentioned in the snapshot. I need to count the total number of Items where Expiration date and received date both are smaller as compared to the 15th of previous month (...
  • johnt75's avatar
    johnt75
    1 year ago

    I think in the EOMONTH you've put 2 instead of -2.

johnt75's avatar
johnt75
Icon for Super User rankSuper User
1 year ago

Make sure that you are using the right column in the SelectedMonth variable. Where it says MAX( 'Date'[Date]) that needs to be a column of type date. It doesn't matter which column you use in the slicer.

sandeep_sharma's avatar
sandeep_sharma
Icon for Helper II rankHelper II
1 year ago

Thanks johnt75 

It is now showing some data atleast. But as I go back in the year, it is reducing the numbers which should not be the case....on investigating I found out that for startcurrentmonth variable it is giving me the data of 1/1/25....any idea why?

 

  • sandeep_sharma's avatar
    sandeep_sharma
    Icon for Helper II rankHelper II
    1 year ago

    Basically it showing me the date of two months ahead....so if I select nov in slicer then it shows Jan'25 and If I select Jun then it shows Aug'24

    • johnt75's avatar
      johnt75
      Icon for Super User rankSuper User
      1 year ago

      I think in the EOMONTH you've put 2 instead of -2.

      • sandeep_sharma's avatar
        sandeep_sharma
        Icon for Helper II rankHelper II
        1 year ago

        This is awesome! Thank you so much! it worked!!