Forum Discussion
gumis_rulez
Helper I
Helper IBas (howtopowerbi) datatable issue
I am trying to recreate Bas Datatable - as everything went ok on his data, I started to implement it on my data. Link to Bas video: https://www.youtube.com/watch?v=pRd_PDsW41A I cannot achieve ...
johnt75
Super User
Super UserThere's a couple of things. You need to add ALLSELECTED(dimCalendar) to the _FirstDate calculation. You also need to make sure that dimCalendar has dates upto 12 months before what's in the order table, otherwise the IF condition will never return true - _PeriodRowLbl will always be less than the min date.