Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Expand table rows by dates range from next row with group

Hi everyone, hope your are good !   I struggle with some manipulation : In this i.e i want to transform dynamically this table :  ID DT_DATE TP_EVENT 1 01/01/2023 OPEN 1 14/01/202...
Need Help
Show and Tell
Tutorial Requests
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Anonymous , Create a date table and join date of date with Dt_date

 

new table

 

Date = calendarauto()

 

then have measures like

 

calculate(lastnonblankvalue(Table[DT_DATE], max(tbale[TP_EVENT])), filter(all('Date'), 'Date'[Date]<= max('date'[Date])))

 

 

Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi, 

     

    Thanks for your suggestion but unfortunatelly it's not the solution i aking for.

     

    I want to expand the table row from date to next date row by ID, dynamicly...

     

    BR