Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi all,
I'm trying to identify the date value of a specific row selected within my table visual and use it to modify an existing measure by replacing the Today() part with that date from the row.
So for the example below I would need to identify that the date value is "2017-07-22" and use it in the measure:
SalesPerDate = CALCULATE(RealTimeData[Total Sales], DATEVALUE(RealTimeData[Date]) = TODAY())
PLEASE NOTE:
This is a streaming dataset and Calculated Columns / Editing Queries etc are not allowed. It has to be a measure to obtain that value and then use it in another measure.
Thanks for any assistance.
Solved! Go to Solution.
@iAm3G wrote:
Hi all,
I'm trying to identify the date value of a specific row selected within my table visual and use it to modify an existing measure by replacing the Today() part with that date from the row.
So for the example below I would need to identify that the date value is "2017-07-22" and use it in the measure:
SalesPerDate = CALCULATE(RealTimeData[Total Sales], DATEVALUE(RealTimeData[Date]) = TODAY())
PLEASE NOTE:
This is a streaming dataset and Calculated Columns / Editing Queries etc are not allowed. It has to be a measure to obtain that value and then use it in another measure.
Thanks for any assistance.
If I understand your request correctly, you just need to remove the filter. The SalesPerDate would vary according to your slicer
SalesPerDate = CALCULATE(RealTimeData[Total Sales])
What is your another measure, the first measure would change according to the context of the another measure.
By the way, is the RealTimeData[Date] a text column?
@iAm3G wrote:
Hi all,
I'm trying to identify the date value of a specific row selected within my table visual and use it to modify an existing measure by replacing the Today() part with that date from the row.
So for the example below I would need to identify that the date value is "2017-07-22" and use it in the measure:
SalesPerDate = CALCULATE(RealTimeData[Total Sales], DATEVALUE(RealTimeData[Date]) = TODAY())
PLEASE NOTE:
This is a streaming dataset and Calculated Columns / Editing Queries etc are not allowed. It has to be a measure to obtain that value and then use it in another measure.
Thanks for any assistance.
If I understand your request correctly, you just need to remove the filter. The SalesPerDate would vary according to your slicer
SalesPerDate = CALCULATE(RealTimeData[Total Sales])
What is your another measure, the first measure would change according to the context of the another measure.
By the way, is the RealTimeData[Date] a text column?
User | Count |
---|---|
5 | |
4 | |
4 | |
2 | |
2 |
User | Count |
---|---|
8 | |
6 | |
4 | |
4 | |
4 |