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, Is there any way to derive a dimension which is expression based and should be evaluated on the fly but not at the time of data refresh?
Hi @aardhala,
Could you please mark the proper answers as solutions?
Best Regards,
Dale
You can have a measure that creates a temp table as a VAR and then use that to perform calculations/filter/etc but not an actual table that gets created in the model.
What is the use case here? Perhaps there is a different way of going about achieving what you are going for here?
Thanks a lot Greg for the tip. The requirement is to create a dynamic Ageing bucket. Can you give any example or a link to see an example on this concept you suggested. i.e. creating Temp Table through variable.
Sure, check out this Quick Measure Gallery item I submitted:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Ranking-and-Aggregations/m-p/498802
I create a temp table using SUMMARIZE and add a Rank column to it for example in order to dynamically calculate the rank of a measure.
Nice feature Greg !Thanks. I will try it out ...
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 |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |