Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi -
I want to combine each of the values from table 1
with all of the dates available in table 2.
can you help advise how to do so?
Thank you! Any help would be much appreciated 🙂
Solved! Go to Solution.
You can create a new table in DAX using Cross Join that will give you desired results.
Table = CROSSJOIN(Country,'Date')
Proud to be a Super User!
You can create a new table in DAX using Cross Join that will give you desired results.
Table = CROSSJOIN(Country,'Date')
Proud to be a Super User!
Hi FarhanAhmed -
Thank you so much for this! It worked 🙂