Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I have three tables, one is a calendar table with dates and a monthID, one is a list of divisions and their creation dates, another is all of the sales for each division and dates of the sale. I want a measure that, when put on a line graph with monthID on the axis, shows the number of branches created in the last 6 months that have also made a sale within the last 6 months? I'm struggling to filter the measure in the list of divisions table based on the sales data. Any help would be appreciated
Solved! Go to Solution.
Hi @uilderton
You may have a look at this article.Attached the sample file for your reference.
Regards,
Hi @uilderton
You may have a look at this article.Attached the sample file for your reference.
Regards,
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
95 | |
86 | |
78 | |
66 |
User | Count |
---|---|
150 | |
118 | |
111 | |
106 | |
95 |