Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
125 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |