Forum Discussion

atowriss1's avatar
atowriss1
Advocate I
3 years ago

DAX Formula Help

I am trying to add a Forecasted Amount to a matrix.  I have a tabale that houses Forecast Only, and it has an active relationship between MthEnd Date in itself and Date on my Date_Table.  The forecas...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi atowriss1 ,

 

Based on your description, you want data after selecting a certain date.
First, for custom required date presentations, we can't associate our fact table with our date table.
We can use the MIN() function to get the date selected by the slicer, and then create a new measure to determine that it is greater than the sum of the date, less than the return of the date BLANK(), and then you can implement your needs.

If this method does not help you, you can provide your sample data in the form of a table or a .pbix file, and provide sample output data in the form of a table so that we can better help you.

 

Best Regards,

Neeko Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.