Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello to everyone
I need help since I managed to crossjoin in a new table all values that are defined for specific dates.
However, i've got the standard prices for the non-campaign times (Which have blank dates):
Solved! Go to Solution.
Create a CALENDAR() table that covers the entire range of dates you want to report against, then use GENERATESERIES() for the dates where you have events, and finally EXCEPT() the two tables which will give you all the dates that do NOT have events.
Create a CALENDAR() table that covers the entire range of dates you want to report against, then use GENERATESERIES() for the dates where you have events, and finally EXCEPT() the two tables which will give you all the dates that do NOT have events.
Thanks Mate!
Is 'Table1 2' a typo?
Are you familiar with the EXCEPT() and INTERSECT() functions?
Hello,
It's just a typo, yes. should just read Table2.
Yeah. I am familiar with those, however not managing to apply them to this here.
Thanks.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |