Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
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.
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
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.)
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.
User | Count |
---|---|
128 | |
108 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |