Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Everybody, I would like to add two new columns to the date table in Desktop (not in the query):
I already have a column for current month:
IsCurrentMonth = IF (YEAR ( Datetable[Date] ) = YEAR ( TODAY () )&& MONTH ( Datetable[Date] ) = MONTH ( TODAY () ), "Yes", "No" )
I would be grateful if you know how to build those two columns above. Many thanks!
Solved! Go to Solution.
This will give you the last Sunday: (as a measure)
This will give you the last Sunday: (as a measure)
Thank you very much Reza. I have the solution now!
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |