Forum Discussion
Helper IIUrgent Relationship
Guys, I'm trying to calculate invoices per year, but when I break the value down, I have two date relationships - order creation date and entry date, the correct value is 10,200.
when I activate the other relationship the same problem, I tried to put a filter of the selected year .. but it didn't work
2 Replies
- Greg_Deckler
Community Champion
Faber13 The short answer is to use CALCULATE along with USERELATIONSHIP and activate the desired relationship as needed. Hard to be more specific than that without additional information.
Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
Faber13Greg_Deckler I already did that and it still didn't work, below are images of the graphics and the base
