Forum Discussion
DAX Measure Error
Sajjad_Hussain , Hope you are using a common Loc and date dimension table
Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solution-8e3eccb41bda
Power BI- Power Query: When I asked you to create common tables: https://youtu.be/PqfGW6pl1Sw
The information you have provided is not making the problem clear to me. Can you please explain with an example.
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.
Dear Amit thankyou for your reply let me upload my pbix file
Actually i want to sum from both tables, table 1 and table 2.
basically its sales data but from two different sources and i want to add them and apply mtd and ytd for it but i cannot as when i click on individual location in table 1, eg. 010 the total Card displays all the sum of location of table 2 which i want only select the 010 location sum from both tables.
Is there any way we can combine all in one table? like in you video you added. I went through it but cannot do it. plz look at my pbix and please let me know.
My Onedrive link to pbix file.
Thankyou for your help.