Forum Discussion
Matrix problems with calendar
mohsenask , I forget to ask. Does the date has a timestamp? And that was the reason. I changed the format of the booking date and checked.
Created a new date column(Without time) and used that is joined. Working now. Please find the find attached after signature
example in case file does not open . One of the two ways, a new column
Date = [booking Date].date
or
Date = date(year([booking Date]),month([booking Date]),day([booking Date]))refer my video, where I covered why TI fails: https://www.youtube.com/watch?v=OBf0rjpp5Hw
amitchandak - thanks i got the file and the solution works.
however i had another measure that is applied to the visual for calculating MoM bookings count.
Bkngs_PrevMnth = CALCULATE(DISTINCTCOUNT('vw_SalesAnalysis_Svcs'[Bookings]),PREVIOUSMONTH(vw_SalesAnalysis_Svcs[Bk Date].[Date])) gives me the count for previous month of Nov 2020 only. No other months show the previous month datathe below formula gives me no prev month count at allBkngs_PrevMnth = CALCULATE(DISTINCTCOUNT('vw_SalesAnalysis_Svcs'[Bookings]),DATEADD(vw_SalesAnalysis_Svcs[Bk Date],-1,MONTH))
mohsenask , I forget to ask. Does the date has a timestamp? And that was the reason. I changed the format of the booking date and checked.
Created a new date column(Without time) and used that is joined. Working now. Please find the find attached after signature
example in case file does not open . One of the two ways, a new column
Date = [booking Date].date
or
Date = date(year([booking Date]),month([booking Date]),day([booking Date]))
refer my video, where I covered why TI fails: https://www.youtube.com/watch?v=OBf0rjpp5Hw
amitchandak - thanks i got the file and the solution works.
however i had another measure that is applied to the visual for calculating MoM bookings count.
thanks - it worked after I deleted and recreated the pageg from scratch
Thank you very much amitchandak