I had a table with 4 columnsID , Date1 ,Date2, Date3
May based on Date 1 has 2 id , date 2 has 1 idRequirement
How could I take shared axis as there is no common field for month
Go to Solution.
View solution in original post
@vijaykumarj19 , Option 1 is unpivot
Option 2 is that you join dates with a same date table and have one active and two inactive join and use userelation to create you measure on each date and add up
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 https://www.archerpoint.com/blog/Posts/creating-date-table-power-bihttps://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/See if my webinar on Time Intelligence can help: https://community.powerbi.com/t5/Webinars-and-Video-Gallery/PowerBI-Time-Intelligence-Calendar-WTD-Y...Appreciate your Kudos.
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.