Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Data by current month

Hey,

 

I dont know what exactly this is called. But i have a command called inmonth(DATE, Today(), -1) as Flag in QlikView to calculate todays date -1 stored in Flag. However, when i calculate the same in power bi through a custom column, it says there is no such thing as inmonth. 

 

Is there an equivalent command for inmonth and inMonths for Power BI, ot in general a command that would work?

 

Thanks a lot! I appreciate the help.

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Try a the below measure :

     

    Measure 3 = EOMONTH(TODAY(),-1)

     

    Thanks

    Raj

  • Anonymous's avatar
    Anonymous
    8 years ago

    Hey, 

     

    I think this may work. Will try and get back. ThankYou!

10 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Anonymous

     

    Please use TODAY()-1 in measure.

     

    If this is the answer you are looking for , then mark the solution as accepted ( Same for your other posts as well, i have responded for couple of qns, but still they are open though they are answered).

     

    Thanks

    Raj

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hey,

       

      The following is the actual syntax of the QlikView command: 

       

      InMonth (timestamp, base_date, period_no)

      timestamp - The date you want to compare the base date with

      base_date - DAte that is used to evaluate the month

      period n0: The month can be offset by period no. It is an integer where 0 indicates the moth which contains base_date. Negative value in period no indiactes preceding month.

       

      So, I need a similar formula in Power Bi to calculate the same.

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Can you pick up a  sample date for this formula and explain what otput you need?

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      So since we are in August month, I would want my to show those values as oj July 31, excluding August. Similarly if we were in September, it needs to show all values as of August 31

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Try a the below measure :

         

        Measure 3 = EOMONTH(TODAY(),-1)

         

        Thanks

        Raj