Forum Discussion

khush19's avatar
khush19
Icon for Resolver I rankResolver I
6 years ago
Solved

Push Dataset in powerBI

I have a requirement where data from Event Hub is continuously coming to Stream Analytics and I am pushing it to POWERBI with a tumbling window of 15 mins.The Push data set will have data for a week....
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi khush19 

    If you can use Power BI Desktop to push data and achieve your requirement,

    (there is a blog :Create a Power BI Push DataSet using Power BI Desktop w/ PowerBIPS.Tools)

    also you are able to create measures in Power BI Desktop,

    you could create the following measures:

    date1 = DATE(YEAR(MAX('Table'[datetime])),MONTH(MAX('Table'[datetime])),DAY(MAX('Table'[datetime])))

now = NOW()

total_now = CALCULATE(SUM('Table'[amount]),FILTER(ALL('Table'),'Table'[date]=TODAY()&&'Table'[datetime]<=NOW()))

total_last week = var lastweek=TODAY()-7 return CALCULATE(SUM('Table'[amount]),FILTER(ALL('Table'),'Table'[date]=lastweek&&'Table'[datetime]<=NOW()-7))

change = [total_now]-[total_last week]

change% = [change]/[total_now]

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi khush19 

Do you use the formula as i provided?

If not, please use my formula instead or show me your formula, i think you may miss something.

 

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
khush19's avatar
khush19
Icon for Resolver I rankResolver I
6 years ago

Yes,I am using your formula:

total_now = CALCULATE(SUM(WeeklyTransactionTable[RealAmount]),FILTER(ALL(WeeklyTransactionTable),WeeklyTransactionTable[date1]=Today()))
 
Infact when i check adding a measure Check=IF(WeeklyTransactionTable[date1]=Today(),"true","fasle"),it works fine.
it is just that it doesnt work in filter
  • khush19's avatar
    khush19
    Icon for Resolver I rankResolver I
    6 years ago

    Hi Maggie,

     

    Thanks for your time and your answer.

    Now filter is working.

    So earlier I was comparing today() with a column of date which was derived from 

    date1 = DATE(YEAR(MAX(WeeklyTransactionTable[MaxTransactionDateTime])),MONTH(MAX(WeeklyTransactionTable[MaxTransactionDateTime])),DAY(MAX(WeeklyTransactionTable[MaxTransactionDateTime])))
    so filter was not working.
     
    Then I compared Today() with one of my column of Datetime with hh:mm:ss as 00:00:00
    and it worked.
     
    Thanku soooooo much 🙂