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.
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?
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 |
---|---|
16 | |
2 | |
2 | |
1 | |
1 |