How to get Data from the Last 6 calendar months with date condition

[Anonymous]

Hi All,

I'm new to powerbi and have tried searching the solution for my problem. I have a table that needs to get the data from the last 6 months but it has condition.
Please help me solve this one.

I need to get the data from the last 6 calendar months or rolling month  with condition

IF Today is March 15, 2020 I should be able to get the data from August 1, 2019 until January 31, 2020
Another example for this one is
IF Today is Feb 27, 2020  I should be able to get the data from August 1, 2019 until January 31, 2020

but  IF Today is March 16, 2020 I should be able to the data from Sep 1, 2019 until  February 29, 2020
basically the data refresh every 16th of the month 

I managed to do this but its wrong.
R6M= if(AND([Today]>15,[Date]=[Month]-7 Else [Date]=[Month]-8

[v-juanli-msft]

Hi @Anonymous 

Is this problem sloved? 

If it is sloved, could you kindly accept it as a solution to close this case and help the other members find it more quickly?

If not, please feel free to let me know.

Best Regards

Maggie

[v-juanli-msft]

Hi @Anonymous 

Create a measure

Measure 2 = CALCULATE(COUNT('Table'[id]),DATESINPERIOD('Table'[date],EOMONTH(TODAY(),-1),-6,MONTH))

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ashish_Mathur]

Hi,

Your conditions are confusing.  The day of Feb 27 and Mar 16 are both after 15, so why should the range of dates for both these be different?

[amitchandak · Accepted solution]

Hope you have a date table

Rolling 6 till  = 
var _count = if(day(today())<16,1,2)*-1
return
CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date],ENDOFMONTH(dateadd(Sales[Sales Date],_count,month)),-6,MONTH))



Rolling 6 till  = 
var _count = (if(day(today())<16,1,2)+6)+-1
return
CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date],startOFMONTH(dateadd(Sales[Sales Date],_count,month)),6,MONTH))

[Anonymous]

hi @amitchandak,

Yes, I have a date table.
Thank you for replying unfortunately its not working. 
What I need is count this number of data from the rolling 6 months 

[amitchandak]

Can you share sample data and sample output. mark me @.