Forum Discussion
Multiple Queries
I did not get it completely. Is it a case of the common time dimension. Means data of the crash month run by crash date and Deposit Month by deposit date and the month year group together as text.
For such a case, you can join a table with date dimension with multiple dates. One will active at time. Follow link how to create and blog on HR to see how both hire and terminations are handled
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s.
Refer
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
Use of dates
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners/ba-p/890814
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
Thanks for replying.
The HR hire/fire is a correct analogy. I'll look closer, at the moment it's not clear where those calculations need to reside and why one relationship is active and the other inactive.
This is very different from SQL... it's frustrating.
DAX works in a different way. Two tables can have only one active relation. More than one relation is like an alias. You need to choose join means alias in the formula.
