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.
hi,
i've seen a few posts about default slicer values, but none that would help in my scenario.
I have two tables, one with a list of emailing sendouts, email, and the date it was sent.
the other is a transactions table with sales per email, the date of the transaction and the amount.
Sendout:
Email, Date, Sendout_name
Transactions:
Email, Date, amount
The key is done on emails, and emails only.
I'd like to show a sum of amount, but with transaction date slicer starting at the date of the sendout.
is that possible?
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
btw @AllisonKennedy , I'm very thankfull for the attention you brought to my post 🙂
I'm just to familiar with the solution you're refering to.
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Hi, unfortunatly, it is not a one to many relation.
Envois _Qv contains many communications, and for every communication there are many recipient emails (NEP is the field in this case linking to my transactions).
And my transactions (Rentrées_de_fonds_FF) can have many transactions for the same email/NEP.
Too late for a follow up? 🙂
@AllisonKennedy I guess many to many relationships won't allow for your solution to work?
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
it is a 1 to many relatinship.
Do you have any links to show me what you are refering to?
hoping for a taker on this 🙂
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |