Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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...
User | Count |
---|---|
21 | |
14 | |
11 | |
8 | |
5 |
User | Count |
---|---|
24 | |
22 | |
20 | |
15 | |
10 |