Data by current month

[Anonymous]

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.

[Anonymous · Accepted solution]

Try a the below measure :

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

Thanks

Raj

[Anonymous]

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]

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 · Accepted solution]

Try a the below measure :

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

Thanks

Raj

[Anonymous · Accepted solution]

Hey, 

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

[Anonymous]

What does Movement[Date] represent? and is MONTH the present month?

[Anonymous]

I had edited the post, pls check again.

[Anonymous]

Thank You. But I think I explained the concept wrong, though the answer is right for that i had explained.

Syntax:

InMonths(n_months, timestamp, base_date, period_no [, first_month_of_year])

For example:

 inmonths(4, '25/11/2012', '01/02/2013', -1 .  Returns True. Because the value of period_no, -1, shifts the search period back one period of four months (the value of n-months), which makes the search period 01/09/2012 to 31/12/2012. 

[Anonymous]

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]

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

[Anonymous]

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.