Not able to filter by different column

Anonymous · ‎05-22-2019

Hi guys,

unfortunately I am not able to filter through another colum for the following measure:

ActualsPriorPeriod =

Var MonthDifference = (DATEDIFF(FIRSTDATE(Period[Date]);LASTDATE(Period[Date]);Month)) + 1

Var StartPeriod = EDATE(FIRSTDATE(Period[Date]); -MonthDifference)

Var EndPeriod = FIRSTDATE(Period[Date]) -1

Return CALCULATE(GuV_Facts[GuV_Actual];DATESBETWEEN(Period[Date];StartPeriod;EndPeriod))

If I set a filter for Period[Date], I can filter. But if I set a filter for another column within the period-table, the does not show a result anymore.

Any ideas, what the problem could be?

Best, Merlin

parry2k · ‎05-22-2019

@Anonymous read this post to get your answer quickly

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Not able to filter by different column

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024