How to create a measure from a streaming dataset in Power BI ?

[Anonymous]

Hi Guys,

Newbie here, is there anyone here who can help me to get the last task based on the date using a measure and show it in a card ?

My datasource is a streaming dataset feeding data from power apps.

OR

If its possible to create a URL filter that will show the same output. That would be match better as I want to show the last task entered by the user thats been using the app.

Thank you so much guys!

[v-lid-msft · Accepted solution]

Hi @Anonymous ,

After we enable the historic data analysis of streaming dataset, we can create measure in Power BI Desktop.

Measure LastDate =
CALCULATE (
    MAX ( 'Table'[Task] ),
    FILTER (
        ALLSELECTED ( 'Table' ),
        'Table'[Date] = CALCULATE ( MAX ( 'Table'[Date] ), ALLSELECTED ( 'Table' ) )
    )
)

Best regards,

[v-lid-msft · Accepted solution]

Hi @Anonymous ,

After we enable the historic data analysis of streaming dataset, we can create measure in Power BI Desktop.

Measure LastDate =
CALCULATE (
    MAX ( 'Table'[Task] ),
    FILTER (
        ALLSELECTED ( 'Table' ),
        'Table'[Date] = CALCULATE ( MAX ( 'Table'[Date] ), ALLSELECTED ( 'Table' ) )
    )
)

Best regards,

[Anonymous]

Also, the download report is disabled.

[v-lid-msft · Accepted solution]

Hi @Anonymous ,

Sorry for that we forgot to mention how to connection this dataset from Desktop, we do not need to download pbix, we can find the dataset connector in Get Data. Then you can search for the streaming dataset

Best regards,

[Anonymous]

Hi Dong,

Thanks for this guys, this will help me with most of my projects in the future.

Thank you so much!

[Anonymous]

Hi V,

My historic data analysis is already enabled but still whenever I am editing the report the options to add measure is still not there.