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.

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

Thanks johnt75 for the response.

However it is giving an error saying cannot convert value 'Oct' of type text to type date. I have double checked, date in slicer has the date format on it........in the Slicer I am taking only Year and Month in one slicer...please suggest

 

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.