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'm really stuck and hoping you can help.
My module contains
My challenge is to create a report visual with the calendar on the x-axis, for example:
My problem is that the output shows the sum of records that match the active relationship, CREATED DATE. In other words, a task completed in March would count in the month the task was created.
This must be a common issue but I must be googling the term.
Thanks in advance
Solved! Go to Solution.
Hello @DonBisset
It is a pretty common problem. Take a look at this post that discusses how to handle it.
https://blog.enterprisedna.co/working-with-multiple-dates-in-power-bi/
As @aj1973 stated above you can use the USERELATIONSHIP function to help you here.
Create two inactive relationships for your other date columns and then you would need to specify them within a CALCULATE function.
For example:
CALCULATE ( SUM ( tasks ), USERELATIONSHIP ( tasks[due date], date[date] ) )
This will use the inactive relationship between due date and your date table rather than the relationship with created date.
Hope this helps!
Hi @DonBisset
To your Model add 2 other inactive relationship between Due date and Completed date to the Calaendar table.
Then add 2 measures using Dax formula USERELATIONSHIP to get the sum for due and completed tasks
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Hello @DonBisset
It is a pretty common problem. Take a look at this post that discusses how to handle it.
https://blog.enterprisedna.co/working-with-multiple-dates-in-power-bi/
Thanks.. your detailed post was exactly what I needed to work through this. Logically it makes sense now, whereas before creating a measure seemed counter-intuitive. This has opened lots of doors to measures now, my model is going to get busy 🙂
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 |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |