- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
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?
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
Subject | Author | Posted | |
---|---|---|---|
01-14-2024 10:22 AM | |||
08-27-2023 04:18 AM | |||
02-13-2024 09:03 PM | |||
03-12-2024 06:49 PM | |||
05-03-2023 11:18 PM |
User | Count |
---|---|
126 | |
81 | |
59 | |
57 | |
43 |
User | Count |
---|---|
183 | |
111 | |
82 | |
65 | |
50 |