Forum Discussion
Creating chart from the table
- 4 years ago
Hi harry6810 ,
According to your description, I create a sample, “Group” is a column of a new table, and “Count ” is a measure.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi harry6810 ,
According to your description, I create a sample, “Group” is a column of a new table, and “Count ” is a measure.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you very much VahidDM , I will try this shortly. In the meantime I have a next question, maybe you will able to help. I will try to briefly describe what I would like to achieve. So, I have 4 main datasets:
- Sales report [WESI]
- Product base [d_product]
- GFK data [GFK]
- Price monitoring [prices]
Each of those tables has common fields - processor, RAM, graphic card etc. Then I created relations in order to link all 4 main datasets, each parameter separately (GPU, CPU, RAM). Additionally, I created relations with next two parameters "series" and "vendor" in a separate table and I added a column with our serie which is the equivalent to a competing one.
And now, I created a hitlist based on the GFK report using all the matched parameters. Based on the "series" table and "match" column, I added a column with our series to the created table. Now the question is how to insert a calculated measure with minimum price [min. price] that will apply to our "match" product and not to the to the oryginal, competitor series? Filtering by manufacturer, of course, returns an empty value. This should work as follows:
- find a product series from the series table [series]'series1' and assign an equivalent from the match column [series]'match' and then get the minimum price [prices][min. price]* for a specific config back from our series from [series]'series1'.
[min. price] is a measure:
[min. price] = CALCULATE(MIN('prices'[lowest_price]),LASTDATE('prices'[data]))