The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi,
To calculate the total number of files in a fact table, I normally only need to take the sum of the column with the total number of files in it, but...
I have a fact table with two dates: date_tk and date_intro_tk. For one date_tk there are several rows with a different date_intro_tk.
There is an active relationship between date_tk and the master calendar and an inactive relationship between date_intro_tk and the master calendar.
I have a slicer on date_tk by using a master calendar, but if i select a month, for instance december 2023, only the data of
date_intro_tk = date_tk - 5 needs to be shown, so date_intro_tk needs to be juli 2023.
Any suggestions?
Thanks,
Jo
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
User | Count |
---|---|
21 | |
20 | |
17 | |
15 | |
13 |
User | Count |
---|---|
42 | |
36 | |
25 | |
22 | |
18 |