Forum Discussion

3 Replies

  • kolturra's avatar
    kolturra
    Helper IV
    8 years ago

    Hi,

     

    Can you please give example like what you are trying to achieve or Will DAX solve your problem?

     

    EMonth = EOMONTH(NOW(),-1) 

     

    Thanks,

    K Raghavender Rao

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi Rao,

       

      In DAX using measured Column it is working:

       

      EOMONTH = EOMONTH(table[date], -1) but data refresh get slow if I use DAX.

       

      But I need to use this function in Query Editor using Conditional/Custom  Column to use EOMONTH in IF formula.

       

      Like excel formula: =IF(table[Date]<=EOMONTH(TODAY(),-1),"PRIOR MONTHS",DUE)

       

      Thanks,

      Salem

      • kolturra's avatar
        kolturra
        Helper IV
        8 years ago

        Hi,

         

        I am working on this query, since i am in learning stage of M QUERY, give me sometime.

         

        Thanks,

        K Raghavender Rao