on the fly Derived Dimensions in power bi

[aardhala]

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?

[v-jiascu-msft]

Hi @aardhala,

Could you please mark the proper answers as solutions?

Best Regards,

Dale

[Greg_Deckler]

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?

[aardhala]

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. 

[Greg_Deckler]

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.

[aardhala]

Nice feature Greg !Thanks. I will try it out ...