Hi, just learning about DAX. Like you vidoes. I followed your lesson here but I continue to get #Error in my column even after adding the value function. ?
Hi Ruth, The month number already sorted on the Model but the month name displayed in the chart isn't sorted. Is this something to do with PB version? I'm using 2.70.5494.761 64-bit (June, 2019) ? Thanks
Week numbers are so tricky to fix... I pull my hair every time I have to do them.. I have to do a deep review on it , I just need time to do figure out all combinations first... /Ruth
@@CurbalEN For the moment I have solved it in SQL. but the logic will be: IF THE FIRST DAY OF THE WEEK OF EACH DATE IS EQUAL TO (FIRST DAY OF THE PRESENT WEEK LESS 1 WEEK) THEN IT IS PART OF THE PREV. WEEK ELSE NOT. It is working for me. Can you transalte it to DAX?
Hola Ruth, mira este video sobre una nueva cualidad de PBI gráfica, para que hagas un gran video sobre esto nos des tu opinión y alcances, un saludo grandote desde Chile ua-cam.com/video/mQpRtVeCy3g/v-deo.html
I am blocking the screen! Sorry about that! I will get out of the way on future videos. ;)
/Ruth
Thank you for all your videos .. it helps me a lot
🎉🎉🎉 glad to hear!
/Ruth
Hola Ruth! existe algo que pueda servir para acumulado del mes pero con cortes diferentes como el año fiscal?
Hi, just learning about DAX. Like you vidoes. I followed your lesson here but I continue to get #Error in my column even after adding the value function. ?
Hi Ruth, The month number already sorted on the Model but the month name displayed in the chart isn't sorted. Is this something to do with PB version? I'm using 2.70.5494.761 64-bit (June, 2019)
? Thanks
Sort the month name by numerical month column
How about creating a parameter and using it in the measure to change which week you are looking at?
Great idea and happy Friday!
/Ruth
As always, it does not work fine:
WEEKNUM("31/12/2018";2) returns 53 and it is 1,
WEEKNUM("01/01/2017";2) returns 1 and it is 52.
:-( :-(
Week numbers are so tricky to fix... I pull my hair every time I have to do them..
I have to do a deep review on it , I just need time to do figure out all combinations first...
/Ruth
@@CurbalEN Yes! I am working on it also ... and also pull my hair every time i try...
If you manage first let me know and we make a video ;)
/Ruth
@@CurbalEN For the moment I have solved it in SQL. but the logic will be:
IF THE FIRST DAY OF THE WEEK OF EACH DATE IS EQUAL TO (FIRST DAY OF THE PRESENT WEEK LESS 1 WEEK) THEN IT IS PART OF THE PREV. WEEK ELSE NOT.
It is working for me. Can you transalte it to DAX?
I am sure it is possible, haven’t tried it, though...
But it is better to do your calendars in power query ;)
/Ruth
Hola Ruth, mira este video sobre una nueva cualidad de PBI gráfica, para que hagas un gran video sobre esto nos des tu opinión y alcances, un saludo grandote desde Chile
ua-cam.com/video/mQpRtVeCy3g/v-deo.html
Hola Eladio, Si, la semana que viene hago el video :)
/Ruth