Forum Discussion

Jramirej's avatar
Jramirej
Regular Visitor
2 years ago
Solved

Create calculated table to generate new rows as per column value

Hi Team, I am searching for one solution over the internet but am unable to find one. Your support is highly appreciated. I have data like below Appointment Date & Time data format is DateTime ...
Need Help
Tips and Tricks
  • amustafa's avatar
    amustafa
    2 years ago

    Alright, DAX calculated table is as following. My sample pbix file has been updated.

     

    Expanded DrTasks = 
GENERATE(
    DrTasks,
    ADDCOLUMNS(
        GENERATESERIES(0, DrTasks[DurationMin] - 1, 1),
        "ExpandedDateTime", DrTasks[AppointmentDateTime] + TIME(0, [Value], 0),
        "DurationMinExpanded", 1
    )
)

     

     

amustafa's avatar
amustafa
Solution Sage
2 years ago

Alright, DAX calculated table is as following. My sample pbix file has been updated.

 

Expanded DrTasks = 
GENERATE(
    DrTasks,
    ADDCOLUMNS(
        GENERATESERIES(0, DrTasks[DurationMin] - 1, 1),
        "ExpandedDateTime", DrTasks[AppointmentDateTime] + TIME(0, [Value], 0),
        "DurationMinExpanded", 1
    )
)

 

 

  • Jramirej's avatar
    Jramirej
    Regular Visitor
    2 years ago

    Works perfectly
    Thanks amustafa for your time and support.