Forum Discussion
Calculate measure for current date
Let me first explain the data structure. There is one table called "Query" with the following columns: "Ticker" (type=text) contains ticker names "Bucket" (type=text) contains time buckets 00-01, 0...
v-danhe-msft
Microsoft Employee
Microsoft EmployeeHi Anonymous ,
Could you please post some simple sample data and your desired result to have a test if possible? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Regards,
Daniel He
Thanks v-danhe-msft for the reply. Here is some sample data in csv format:
Ticker;Bucket;ID;Score;Date
EIB;00-01;EIB1;30;20.02.2019
EIB;01-03;EIB1;27;31.01.2019
IADB;05-07;IADB1;53;20.02.2019
IADB;07-10;IADB1;85;31.01.2019