Hi ,
I have to create a power BI report which takes data from a cube which inturn is pulling data from DB .
DB has tables with ETL loads being performed once or more per day and each load is spread across multiple load timestamps .
so when I have to show a given batch grouped by the selecting the load date , i need to show loads executed for that day followed by no of records loaded for each batch .
I can ideally have load date being uniform across all the load but the DB currently only holds load timestamp values that are different and I dont want to make changes at the DB level and handle is only at power BI level.
could you please help
