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 ...
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!

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 of July 31, excluding August. Similarly if we were in September, it needs to show all values as of August 31. At the beginning of each month, the flag value shows the values as of the end of the previous month.