Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I have a fact table with multiple dates and one date table witch contains year and month etc.
In the fact table i have an date witch contains the creationdate and a date witch contains the the the item has been resolved.
I want to create two different barcharts
I created one active relation between the fact table on creation date and date in the date table
Please help.
Thanx
There are two ways. You can create one more relation between two tables. With another date in fact. That will be inactive. And In case you need another date. In your calculate formula you can activate another date. using userealtion.
In case there are too many measures on both dates. You can create one more copy of the date table and join with another date.
Date2 = date
Hi Thanx, for your information.
Can you tell me how the dax formula looks like when i want to retrieve the month for the inactive relationship date field?
Thank you.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |