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.
Dear Team,
I have three different data-sheet in Power Bi and trying to build a relationship based on the date dimension table but facing the below error.
scenario
When I use each table wk# to create a visual in PBI, the data spread is correct for each data sheet week on week basis.
However, when I create many to many relationships (suggested by Power query automatically and without any other option), the table visual or line chart shows the total quantity only each week instead of each week's quantity. Kindly see below some sample data tables.
Hi @HZAFAR ,
Create a calender table. Build all relationships with this calender table and check.
Use following DAX code to create calender table.
Calender = CALENDAR (DATE (2022, 1, 1), DATE (2023, 12, 31))
Thank you.
This is not working.
secondly i need to create week number and DAX function is not giving me the correct wek day as complared to excel based formula (=ISOWEEKNUM(Date)
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 |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |