MTD Revenue vs. QTD Revenue

Jpahl2033 · ‎07-19-2023

Hi,

I would like help with figuring out this problem. Right now I have two data sources. One that has MTD revenue and one that has QTD revenue. I would like to have a DAX expression helping me that if there is no QTD revenue for that month, we will use the MTD revenue number. Let me know if that is possible.

v-shex-msft · ‎07-24-2023

Hi @Jpahl2033,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

amitchandak · ‎07-19-2023

@Jpahl2033 , If they have common dimension then you can have measure like

if(isblank([QTD]), [MTD], [QTD])

!! Power BI 101 Interview questions !! !! Master Microsoft Fabric- 36 Videos !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!