From the above highlighted From date value in date slicer,I need to write measure
Just looking at your Initial question;
Try adding the Min date to a Variable.
VAR MIN = Min(TransactiondateDate)
VAR MAX = Max(TransactiondateDate)
If I use MIN(transactiondate) then it will be same as the user selected values from the date slicer?
Because what I basically need is,I should get the data from the exact value choosen by user that too in the highlighted part from the attached screenshot i.e.; assume(From Date)
Why dont you try and find out ? 😉
But if you use a visual that is filtered trough that slicer.
Your min and max date will indeed be the one selected in the slicer (make sure you use the same column in the measure as in the slicer)
You'll have to adjust to something like this:
Ideally you would use a DateDimension though
measure= VAR minDate = MIN(table1[Date]) VAR maxDate = MAX(table1[Date]) RETURN CALCULATE( SUM(table1[qty]), FILTER(table1,table1[Type]="VS"), FILTER(table1,table1[Date] >= minDate), FILTER(table1,table1[Date] <= maxDate), GROUPBY(table1,table1[Item]) )
Looking for your support here.
Facing an issue using the measure you've shared with me.
2) Opening = IF(ISBLANK([AA Opng measure]),0,[AA Opng measure])
That measure works fine when the excel sheet contains exact data,but it's returning the same value for the date which is not there in the sheet.
In sheet there are only 3 dates that is 1-Aug-2019,16-Aug-2019 and 5-Aug-2019.If I select Date other than these I should get Zero,but actually for 6th aug 2019 the value of 16th aug 2019 is showing.
Please help me resolve this.
Please find the attached sample data for your reference,hope you will get to know what is the exact issue.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.