Forum Discussion
Select values based on conditions
So I have 3 tables, one with locations and 2 with sales and dates. My dev didn't created dates tabel, so my question is:
Can you use dax to select columns based on condition, and that would be vendor from locations table ? e.g. if Vendor is Ven1 then use dates and sale amounts from Sales1 table and if Vendor is Ven2 then use data from Sales2. I would like to use this on axis in chart and slicer. I can't create column since it's in Azure
Hi Krcmajster ,
If i understand you correctly, you can use UNION() function to create a calculated table which contains table1 and table2 then use vendor as silcer if you want.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
Hi Krcmajster
I believe this is possible, can you provide a subset of data so that I can look at a relevant measure? I I need a bit more information about the vendor and sales values and how they are currently stored.
Thanks
shebr Best I could do. The tables are not the same and the connection is more complicted but I can solve this if I have solution for this
Hi Krcmajster ,
If i understand you correctly, you can use UNION() function to create a calculated table which contains table1 and table2 then use vendor as silcer if you want.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If the tables are related you could use an IF() based on your vendor. For example:
IF( [vendor] = "Ven1",
CALCULATE( SUM( 'Sales1'[Sales] ), 'Sales1'[Dates] ),
CALCULATE( SUM( 'Sales2'[Sales] ), 'Sales2'[Dates] )
)(If the vendor is "Ven1" uses first calculate function with Sales1 table, else, use second calculate with Sales2 table.)
I can't create column since it's in Azure A measure cannot be used in in a chart or slicer. It has to be a column.
where are you creating the report? Is your source a dataset?
If it helps, mark it as a solution
Kudos are nice too
