Reply
Yegor
New Member
Partially syndicated - Outbound

temporary dynamic table

Hi There!

 

I have model like:

- data002=my fact table

- others(calendar_l, id_postav_l, id_shop_l, v_type_l)=dimension tables for slicers

Yegor_0-1681307204158.png

 

trying to acheve futher goal:

1) set date period via slicer, based on "calendar_l"

2) set shop via slicer, based on "id_shop_l"

3) set dealer via slicer, based on "id_postav_l"

4) get temporary table, based on "data002", where I wont to group rows by: item_ID, Shop_ID % dealer ID + add min price for period

5) create histogram based on my temporary table - from "4)"

 

So the main question is for step "4)" - how can I create temp table, which can be modyfied by slicers(on the fly) & become base for histogram?

 

 

0 REPLIES 0
avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)