I have 8 different tables which are all connected through different columns. In one table, I have calculated Revenue and created a new column to show it. However, when I visualize it on report part, the Date does not work properly.
The 2 tables in question are connected via another table I created with a UniqueID (since Many:Many is not possible) that is present in both tables. My Measure with Revenue looks like SUMX(TableName; [UnitPrice] * [Quantity] * (1-[Discount])). Each row has an ID and that ID is supposed to be identified in the second table to relate to the Date in another column.
When I add the Date, it just shows the Total Revenue for each year/month, there are no differences. While in Qlik Sense it automatically identified everything and made a normal graph Revenue by Year/Month.
Thanks for your help.
When I add the Date, it just shows the Total Revenue for each year/month, there are no differences.
You may need to drag [Date] from bridge date dimention table to visual.
Glad to hear that it has been resolved. Would you please kindly share your solution so that it can benefit more users?
So, it's hard to explain exactly without showing my tables, but I fixed some of the relationships between the tables and it works now. It's all about relationships. 🙂 If you want to know more, I can show you in pm.
Will need to see sample data and expected results. Tough to comprehend what is going on without it. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490...
I have written some Quick Measures that may or may not be of use, can't really tell with the information presented: