topic Re: PREVIOUSQUARTER Function not give correct value in Card in DAX Commands and Tips

PREVIOUSQUARTER Function not give correct value in Card

Sandeep13 — Fri, 09 Jun 2023 16:44:30 GMT

Hello,

I want to show last QUARTER amount in my card but its showing blank.

In below image you can see I selected 2 years from year filter and all 4 qtrs.

In table matrix my measure PQQ is working fine but in Card it gives blank.
But I am expecting values 31794150 which is in RED circle as my previous qrt value.

Please let me know how can to fix this.

Thanks in Advance.

power alexp ramicortes powerbi2 dbaexperts Anonymous

Re: PREVIOUSQUARTER Function not give correct value in Card

Greg_Deckler — Fri, 09 Jun 2023 16:38:12 GMT

Sandeep13 You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000

Also, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008

Re: PREVIOUSQUARTER Function not give correct value in Card

Sandeep13 — Fri, 09 Jun 2023 16:52:16 GMT

Greg_Deckler Thanks but your links are very useful but in my case is differenct.
I want to show previous Qtr values in CARD but its showing blank.

Re: PREVIOUSQUARTER Function not give correct value in Card

Greg_Deckler — Fri, 09 Jun 2023 18:37:06 GMT

Sandeep13 Can you share sample data that can replicate the issue? As text preferrably or a PBIX file link.

Re: PREVIOUSQUARTER Function not give correct value in Card

Anonymous — Tue, 13 Jun 2023 02:59:08 GMT

Hi Sandeep13 ,

Please create a new measure:

PQQ 2 = IF ( ISBLANK ( SELECTEDVALUE ( 'Date_table'[Year] ) ) && ISBLANK ( SELECTEDVALUE ( 'Date_table'[Quarter] ) ), CALCULATE ( [PQQ], 'Date_table'[Year] = MAX ( 'Date_table'[Year] ) && 'Date_table'[Quarter] = MAX ( 'Date_table'[Quarter] ) ), [PQQ] )

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data in the Power BI Forum

Re: PREVIOUSQUARTER Function not give correct value in Card

Sandeep13 — Thu, 15 Jun 2023 09:32:08 GMT

Hi ,

Your above dax code is still giving me blank values.

FYI : In my calender Table I have date till 31 dec 2023.