Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowGet certified as a Fabric Data Engineer: Check your eligibility for a 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700. Get started
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
146 | |
72 | |
63 | |
52 | |
51 |
User | Count |
---|---|
208 | |
91 | |
62 | |
59 | |
56 |