topic Help with a DAX Query: MIN Date as x-axis to my chart in DAX Commands and Tips

Help with a DAX Query: MIN Date as x-axis to my chart

Lsh0576 — Mon, 22 May 2023 20:18:50 GMT

Hello there! I was wondering if someone can help me this chart I am trying to develop. The bar chart I am trying to create has the following:

x-axis = Min date of appraisal submission date

y-axis = count of appraisals

My table has rows for each submission date so I would only want to grab the earliest submitted date and count the # of appraisals submitted on that date.

Thank you in advance for your assistance.

Lovella

Re: Help with a DAX Query: MIN Date as x-axis to my chart

Anonymous — Wed, 24 May 2023 08:13:58 GMT

Hi Lsh0576 ,

I created some data:

Here are the steps you can follow：

1. Create measure.

Flag = IF( MAX('Table'[appraisal submission date])= MINX(ALL('Table'),[appraisal submission date]),1,0)

2. Place [Flag]in Filters, set is=1, apply filter.

3. Result:

Best Regards,

Liu Yang

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

Re: Help with a DAX Query: MIN Date as x-axis to my chart

Mrxiang — Wed, 24 May 2023 08:20:59 GMT

Sure, I can help you with that. You can use the DAX function MIN to get the earliest submission date and then use the COUNTROWS function to count the number of appraisals submitted on that date. Here's an example DAX formula: Appraisals Count = COUNTROWS(FILTER('Table', 'Table'[Submission Date] = MIN('Table'[Submission Date]))) Replace 'Table' with the name of your table and 'Submission Date' with the name of your submission date column. This formula will give you the count of appraisals submitted on the earliest submission date. You can use this formula in your bar chart's y-axis.

Re: Help with a DAX Query: MIN Date as x-axis to my chart

Lsh0576 — Thu, 25 May 2023 18:52:37 GMT

Thank you for this. I realized that all of my formulas were solved via switching to import mode (from Direct Query..too much limitations). But I appreciate the assistance! Have a great day!