- 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
Show data of a month of one date while selecting a month of another date
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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...

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
12-28-2023 05:16 PM | |||
09-21-2023 11:02 PM | |||
05-23-2023 07:18 PM | |||
04-01-2024 07:17 PM | |||
01-10-2024 01:32 AM |
User | Count |
---|---|
14 | |
14 | |
11 | |
11 | |
8 |