Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
105 | |
78 | |
68 | |
63 |
User | Count |
---|---|
148 | |
107 | |
106 | |
84 | |
70 |