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.
Hi,
I'm trying to create a measure A which runs a measure B within a specific date set by a measure C. Measure C is just a date rank that lets pick a specific date as a rank relative to the latest date (i.e. rank 1 ~ latest date, rank 2 ~ 2nd available date, and so on). So then I can have multiple measures of Measure A with different date ranks specified for different dates so that the output visualization can have multiple columns of measure B for different dates. Something like
Device | %GT as of 11/19/2018 | %GT as of 11/20/2018 | %GT as of 11/21/2018
Device1| ...
Device2|
If I use a date rank calculated via a calculated column instead of the one from Measure C, it works but it's not what I need as I need the report to allow to adjust dates on the page and the dates to be relative to the latest selected.
Measure C: is a date rank to let report select 1st, 2nd, 3rd date going back from the latest.
Hi,
Share a sample dataset and also show the expected result.
I've tested this on a small sample dataset and it works there as expected. Looking again at my main dataset which is ~20M rows, it appears that the problem is that the Measure C doesn't finish to resolve (it's over five minutes after adding it into Values field in Matrix chart and it still spinning).
Am I doing anything blatantly wrong that would make it take so long? Especially, If a version below with hardcoded date works fast, how come the one version with FIRSTDATE(...) doesn't resolve as fast? Is the TargetDate query called for each row?
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |