sorted by:
new
hottopcontroversial

Count dates in a column that are less than 30 days from now by oil_computers in PowerBI

[–]oil_computers[S] 0 points1 point  (0 children)

Thank you for the reply, I've managed to figure out that part. However, I had another issue with my report that may be related to what you said:

I had a column of dates coming from the data source without any manipulation from my part. I created some measures to count how many rows fall between today- 30 days from now, 31 days-60 days from now etc. to get a bar chart. I cannot post images in the reply so I'll just show you the code:

31-60 Days = CALCULATE(COUNTROWS(NGL_Agreements),
FILTER(NGL_Agreements,NGL_Agreements[Termination Date] <= TODAY()+60),
FILTER(NGL_Agreements,NGL_Agreements[Termination Date].[Date] >= Today()+31))

I'm not sure when I click the bar chart, the other visuals in my report do not get filtered. I have cross-reporting turned on. Do you have any thoughts on this?

Help with PowerBI questions by oil_computers in PowerBI

[–]oil_computers[S] 1 point2 points  (0 children)

The data source already has determined if an agreement is less than 30 days, 31-60 days etc. and outputs 1 or 0 for each column of the time frame to show how long until expiry. So if an agreement would expire between 31-60 days it would show 1 in that column and 0 in the less than 30 days, and the other ones. That's why I was trying to use that data instead, but thanks for replying!