Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
The quick measure YoY% is giving me results for the future 12 months. I want the YoY% to only match the dates for which there is data (Purchases). My data ends in 12/2017 and I want the YoY% to stop on 12/2017.
Purchases YoY% =
IF(
ISFILTERED('qCalendar'[FirstDayofMonth]),
ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column."),
CALCULATE(
SUM('qPurchaseHistory'[Purchases]),
DATEADD('qCalendar'[FirstDayofMonth].[Date], -1, YEAR)
)
)
Thanks in advance.
Solved! Go to Solution.
Hi @dogcat,
You are using a calendar column on your graph right?
Just go on the visual filter and all non blank on the Purchase values will filter out all the dates that are blank in the purchase.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @dogcat,
You are using a calendar column on your graph right?
Just go on the visual filter and all non blank on the Purchase values will filter out all the dates that are blank in the purchase.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsYes on the calendar table. I was trying so hard to filter by date it didn't occur to filter by presence of or lack of a value. Thanks.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |