Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
The data is Transaction data where I have Amount and Transaction Date
For my requirement i need 3 charts
as I am using the tumbling window of 15 mins so i wont have transaction exactly till 6:41 but at least Amount where Max(Transaction Date)<= CurrentTime (6:41) for that day .
I am not sure how can I achieve 2nd and 3rd?
Solved! Go to Solution.
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]
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]
Thanks Maggie,
But filter doesn't work for me.it return blank
.
I tried putting Today() in different measure but no use.
When i use IF to compare date1 with today() it is correct as required but doesn't work in filter.
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.
Yes,I am using your formula:
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
User | Count |
---|---|
103 | |
87 | |
77 | |
70 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |